IMPORT DATABASE --> FROM <file-spec> -+
+--------------------------------------+
+-+-> FILENAME <file-spec> --+----------------------+-+
| +-> literal-user-auth -+ |
+-> WITH ALIAS <alias> -----------------------------+
+----------------------------<------------------------+
++-+--------------------------------------+-+----------->
| +-> import-options --------------------+ |
| +-> character-sets --------------------+ |
| +-> import-root-file-params-1 ---------+ |
| +-> import-root-file-params-2 ---------+ |
| +-> import-root-file-params-3 ---------+ |
| +-> import-root-file-params-4 ---------+ |
| +-> storage-area-params-1 -------------+ |
| +-> storage-area-params-2 -------------+ |
| +-> create-clause/statement -----------+ |
| +-> drop-statement --------------------+ |
+-----------------<------------------------+
literal-user-auth =
---> USER '<username>' -+------------------------+-->
+-> USING '<password>' -+
import-options=
-+-+-------+-+-> ACL ----------------+-+--->
| +-> NO -+ +-> BANNER -------------+ |
| +-> BATCH UPDATE -------+ |
| +-> CDD LINKS ----------+ |
| +-> DATA ---------------+ |
| +-> FORWARD_REFERENCES -+ |
| +-> TRACE --------------+ |
+-> COMMIT EVERY TABLE --------------+
+-> COMMIT EVERY n ROWS --------------+
character-sets =
-+-+--> DEFAULT CHARACTER SET <support-char-set> --+-+->
| +--> NATIONAL CHARACTER SET <support-char-set> -+ |
| +--> IDENTIFIER CHARACTER SET <names-char-set> -+ |
| +--> DISPLAY CHARACTER SET <support-char-set> ----+
+---------------------- <---------------------------+
import-root-file-params-1 =
-+-> PATHNAME <path-name> -----------------------------+->
+-> attach-options -----------------------------------+
+-> COLLATING SEQUENCE <sequence-name> ------+ |
| +-----------------------------------------+ |
| ++---------------+----+----------------+--+ |
| +-> COMMENT IS -+ +-> '<string> ' -+ | |
| +-----------------------------------------+ |
| +--> <ncs-name> -+-----------------------+---------+
| +-> FROM <library-name> + |
+-> NUMBER OF USERS --> <number-users> ---------------+
+-> NUMBER OF BUFFERS -----> <number-buffers> --------+
+-> NUMBER OF CLUSTER NODES ----> <number-nodes> --+ |
| +---------------------------------------------+ |
| +-+-----------------------------------------+----+
| +-> ( -+-> SINGLE ---+-> INSTANCE --> ) --+ |
| +-> MULTIPLE -+ |
+-> NUMBER OF RECOVERY BUFFERS -> <number-buffers> |
+-> BUFFER SIZE IS -> <buffer-blocks> -> BLOCKS ------+
+-> global-buffer-params -----------------------------+
attach-options =
-+-> DBKEY -+-> SCOPE IS -+-> ATTACH -------+-----------------------+->
+-> ROWID -+ +-> TRANSACTION --+ |
+-> MULTISCHEMA IS -+-> ON --+-------------------------------------+
| +-> OFF -+ |
+-> PRESTARTED TRANSACTIONS ARE -+-> ON --+------------------------+
| +-> OFF -+ |
+-+-------+-> RESTRICTED ACCESS -----------------------------------+
+-> NO -+
global-buffer-params=
--> GLOBAL BUFFERS ARE -+-> ENABLED --+--------------+
+-> DISABLED -+ |
+----------------------------------------------------+
+---------------------------------------------------+--->
+> ( -++-> NUMBER IS <number-glo-buffers> ----++> ) +
|+-> USER LIMIT IS <max-glo-buffers> ---+|
|+-> PAGE TRANSFER VIA --+-> DISK ---+--+|
|| +-> MEMORY -+ |
|+-> LARGE MEMORY IS --+--> ENABLED --+--+
| +--> DISABLED -+ |
+------------------- , <----------------+
import-root-file-params-2 =
-+-> SNAPSHOT IS -+> ENABLED -+-> IMMEDIATE --+-+------------------+->
| | +-> DEFERRED ---+ | |
| +> DISABLED ------------------+ |
+-> DICTIONARY IS ---+---> REQUIRED -------+----------------------+
| +---> NOT REQUIRED ---+ |
+-> ADJUSTABLE LOCK GRANULARITY IS -+-> ENABLED -> alg-options -+-+
| +-> DISABLED ---------------+ |
+-> LOCK TIMEOUT INTERVAL IS <number-seconds> SECONDS ------------+
+-> SEGMENTED STRING -+-> STORAGE AREA IS <area-name> ------------+
+-> LIST -------------+ |
+-> DEFAULT ----------+ |
+-> PROTECTION IS ---+---> ANSI --+-------------------------------+
| +---> ACLS --+ |
+-> RESERVE <n> --+-> CACHE SLOTS -----+--------------------------+
+-> JOURNALS --------+
+-> STORAGE AREAS ---+
+-> SEQUENCES -------+
alg-options =
--+------------------------------+-->
+-> ( --> COUNT IS <n> --> ) --+
import-root-file-params-3 =
-+> CARDINALITY COLLECTION IS --------------+--+-> ENABLED --+--------+>
+> CARRY OVER LOCKS ARE -------------------+ +-> DISABLED -+ |
+> GALAXY SUPPORT IS ----------------------+ |
+> LOCK PARTITIONING IS -------------------+ |
+> LOGMINER SUPPORT IS --------------------+ |
+> METADATA CHANGES ARE -------------------+ |
+> STATISTICS COLLECTION IS ---------------+ |
+> WORKLOAD COLLECTION IS -----------------+ |
+> SYSTEM INDEX -+-> COMPRESSION IS -+-> ENABLED ---+-----+----------+
| | +-> DISABLED --+ | |
| +-> ( -+-> system-index-options -+-> ) --+ |
| +---------- , <-----------+ |
+> PRESTARTED TRANSACTIONS ARE +> ENABLED -> prestart-trans-options ++
| +> DISABLED -------------------------+|
+> SECURITY CHECKING IS ---> security-checking-options --------------+
+> SYNONYMS ARE ENABLED ---------------------------------------------+
system-index-options =
-+-> COMPRESSION IS --------------------------------++- ENABLED -++->
+-> PREFIX CARDINALITY COLLECTION IS --------------++> DISABLED +|
+-> PREFIX CARDINALITY COLLECTION IS ENABLED FULL ---------------+
+-> TYPE IS SORTED --+-----------+-------------------------------+
+-> RANKED -+
prestart-trans-options =
-+---------------------------------+->
+-> WAIT <n> SECONDS FOR TIMEOUT -+
+-> WAIT <n> MINUTES FOR TIMEOUT -+
+-> NO TIMEOUT -------------------+
security-checking-options =
-+-> EXTERNAL -+------------------------------------------------++->
| +-> ( -> PERSONA SUPPORT IS -+-> ENABLED --+> ) -+|
| +-> DISABLED -+ |
+-> INTERNAL -+-----------------------------------------------+-+
+-> ( -> ACCOUNT CHECK IS -+---> ENABLED --+> ) +
+---> DISABLED -+
import-root-file-params-4 =
-+-> ASYNC BATCH WRITES ARE --+-> ENABLED --> async-bat-wr-options -+-+>
| +-> DISABLED -------------------------+ |
++------------+-> ASYNC PREFETCH IS --+ |
|+> DETECTED -+ +-------------------+ |
| +-+-> ENABLED ---> async-prefetch-options +--------+
| +-> DISABLED ---------------------------+ |
+-> ROW CACHE IS -+-> ENABLED --+-+----------------------+-----------+
| +-> DISABLED -+ +-> row-cache-options -+ |
++------+-> INCREMENTAL BACKUP SCAN OPTIMIZATION --------------------+
|+> NO -+ |
+-> MULTITHREAD AREA ADDITIONS ----> multithread-options ------------+
+-> RECOVERY JOURNAL -> ( -> ruj-options -> ) -----------------------+
+-> SHARED MEMORY IS --+-> SYSTEM ---------------------+-------------+
+-> PROCESS --+-------------+---+
+-> RESIDENT -+
asynch-bat-wr-options =
-+----------------------------->-------------------------------+->
+ ( ++-> CLEAN BUFFER COUNT IS <buffer-count> BUFFERS --++> ) +
|+-> MAXIMUM BUFFER COUNT IS <buffer-count> BUFFERS +|
+------------------- , <-----------------------------+
async-prefetch-options =
--+-----------------------------------------------------------+>
+-> ( -+-+-> DEPTH IS <number-buffers> BUFFERS -----+--+> )-+
| +-> THRESHOLD IS <number-buffers> BUFFERS -+ |
+----------------- , <--------------------------+
row-cache-options =
-> ( -++-> CHECKPOINT -+-> ALL ROWS TO BACKING FILE -----------+-++-> ) -->
|| +-> TIMED EVERY <n> SECONDS ------------+ ||
|| +-> UPDATED ROWS TO -+-> BACKING FILE -++ ||
|| +-> DATABASE -----+ ||
|+-> LOCATION IS --> <directory-spec> ---------------------+|
|+-> NO --+--> LOCATION --------+--------------------------+|
|| +--> SWEEP INTERVAL --+ ||
|+-> NUMBER OF SWEEP ROWS IS <n> --------------------------+|
|+-> SWEEP INTERVAL IS <n> SECONDS ------------------------+|
+-------------------------- , <-----------------------------+
multithread-options =
---+-----------------------------------------+-->
+-> ( --+-> ALL AREAS -----------+--> ) --+
+-> LIMIT TO <n> AREAS --+
ruj-options =
-+-> LOCATION IS --> <directory-spec> -+-->
+-> NO LOCATION ----------------------+
+-> BUFFER MEMORY IS -+-> LOCAL ------+
+-> GLOBAL -----+
storage-area-params-1 =
--+-> ALLOCATION IS ---> <number-pages> --> PAGES -----+->
+-> CACHE USING <row-cache-name> --------------------+
+-> NO ROW CACHE ------------------------------------+
+-> extent-params -----------------------------------+
+-> INTERVAL IS --> <number-data-pages> -------------+
+-> LOCKING IS --+-> ROW --+--> LEVEL ---------------+
| +-> PAGE -+ |
+-> PAGE FORMAT IS +-> UNIFORM -+--------------------+
| +-> MIXED ---+ |
+-> PAGE SIZE IS ----> <page-blocks> --> BLOCKS -----+
extent-params =
--+-> EXTENT IS -+-> ENABLED -------------------++-->
| +-> DISABLED ------------------+|
| +-> <extent-pages> --> PAGES --+|
| +-> (extension-options) -------+|
+---------------------<------------------------+
extension-options =
---> MINIMUM OF <min-pages> PAGES, --+
+------------------------------------+
+--> MAXIMUM OF <max-pages> PAGES, --+
+------------------------------------+
+--> PERCENT GROWTH IS <growth> ------->
storage-area-params-2 =
--+-> CHECKSUM CALCULATION IS -----------+--+-> ENABLED --+-+->
+-> SNAPSHOT CHECKSUM CALCULATION IS --+ +-> DISABLED -+ |
+-> SNAPSHOT ALLOCATION IS --> <snp-pages> ----> PAGES ---+
+-> SNAPSHOT EXTENT IS -+-> <extent-pages> ----> PAGES --++
| +-> (extension-options) ---------+|
+-> SNAPSHOT FILENAME --> <file-spec> --------------------+
+-> THRESHOLDS ARE ( <val1> +-----------------------+> ) -+
| +> ,<val2> -+----------++ |
| +> ,<val3> + |
+------------------------------<--------------------------+
create-clause/statement =
-+-> create-cache-clause -----------+->
+-> create-index-statement --------+
+-> create-storage-area-clause ----+
+-> create-storage-map-statement --+
drop-statement =
---+-> DROP CACHE <row-cache-name> -----+->
+-> DROP INDEX <index-name> ---------+
+-> DROP STORAGE AREA <area-name> ---+
+-> DROP STORAGE MAP <map-name> -----+