What is Data instantiation
...
3. On the source server (dbv01) start the APPLY.sh script. This script will take approximately 25 minutes to complete.
| No Format |
|---|
$ ./APPLY.sh Import: Release 12.1.0.1.0 - Production on Fri Aug 1 05:2531:4743 2014 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options Starting "SYSTEM"."DP_DBVREP_ORCL_0001": SYSTEM/********@ttorcl_trg table_exists_action=TRUNCATE network_link=ttorcl_src directory=ttorcl_trg_DATA_PUMP_DIR flashback_scn=144916713144204 tables=OE.ADDRESSES,OE.CARD_DETAILS,OE.CMP35780,OE.CMP45780,OE.CUSTOMERS,OE.INVENTORIES,OE.LOGON,OE.ORDERENTRY_METADATA,OE.ORDERS,OE.ORDER_ITEMS,OE.PRODUCT_DESCRIPTIONS,OE.PRODUCT_INFORMATION,OE.PROMOTIONS,OE.WAREHOUSES logfile=OE_WAREHOUSES.log JOB_NAME=DP_dbvrep_orcl_0001 Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 1.008016 GB Processing object type TABLE_EXPORT/TABLE/TABLE Table "OE"."PROMOTIONS" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate . . imported "OE"."ORDER_ITEMS" 42900234291621 rows . . imported "OE"."INVENTORIES" 900632899846 rows . . imported "OE"."ORDERS" 14297901430027 rows . . imported "OE"."ADDRESSES" 15000001500112 rows . . imported "OE"."CUSTOMERS" 10000001000103 rows . . imported "OE"."CARD_DETAILS" 15000001500103 rows . . imported "OE"."LOGON" 23829842383613 rows . . imported "OE"."PRODUCT_DESCRIPTIONS" 1000 rows . . imported "OE"."PRODUCT_INFORMATION" 1000 rows . . imported "OE"."ORDERENTRY_METADATA" 4 rows . . imported "OE"."WAREHOUSES" 1000 rows . . imported "OE"."PROMOTIONS" 0 rows Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS Processing object type TABLE_EXPORT/TABLE/INDEXCONSTRAINT/FUNCTIONAL_AND_BITMAP/INDEXREF_CONSTRAINT Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS TABLE_STATISTICS Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER ORA-39166: Object OE.CMP35780 was not found. ORA-39166: Object OE.CMP45780 was not found. Job "SYSTEM"."DP_DBVREP_ORCL_0001" completed successfully completedwith 2 error(s) at 20:20:50Fri Aug 1 05:38:02 2014 elapsed 0 00:06:14 [oracle@source dbvrep_orcl]$ |
...