Capture
Creation - Using add_schema_rules procedure
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/SE_PRE_SCHEMA_PROCOBJACT/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/PROCACT_INSTANCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "NY2"."ALLINSURED2"
1.128 MB 6000 rows
. . imported
"NY2"."BRANCH2" 2 KB 12 rows
. . imported
"NY2"."SALESPERSON2" 3 KB 15 rows
. . imported
"NY2"."TEST1" 1 KB 1 rows
Job "STRMADM"."SYS_IMPORT_FULL_01"
successfully completed at 00:29
The next step is the instantiation of the
schema and its objects using the procedure
set_schema_instantiation_scn:
PROMPT Step(8) Instantiate the Schema
Objects
DECLARE
iscn NUMBER; -- Variable to hold
instantiation SCN value