;;; Import: Release 10.1.0.2.0 - Production on Saturday, 16 April, 2005 16:19 Copyright (c) 2003, Oracle. All rights reserved. ;;; Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options Master table "SYSTEM"."REFRESHSHTABLES" successfully loaded/unloaded Starting "SYSTEM"."REFRESHSHTABLES": system/******** PARFILE=c:\rmancmd\RefreshSHTables.dpictl Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA ORA-39120: Table "SH"."CUSTOMERS" can't be truncated, data will be skipped. Failing error is: ORA-02266: unique/primary keys in table referenced by enabled foreign keys ORA-39120: Table "SH"."PRODUCTS" can't be truncated, data will be skipped. Failing error is: ORA-02266: unique/primary keys in table referenced by enabled foreign keys . . imported "SH"."COUNTRIES" 6.554 KB 19 rows . . imported "SH"."SALES":"SALES_Q1_1999" 2.790 MB 86217 rows . . imported "SH"."SALES":"SALES_Q1_2000" 3.375 MB 104544 rows . . imported "SH"."SALES":"SALES_Q2_1999" 2.824 MB 87298 rows . . imported "SH"."SALES":"SALES_Q2_2000" 3.375 MB 104652 rows . . imported "SH"."SALES":"SALES_Q3_2000" 2.945 MB 91260 rows . . imported "SH"."SALES":"SALES_Q4_1998" 2.701 MB 83415 rows . . imported "SH"."SALES":"SALES_Q4_1999" 3.231 MB 100110 rows . . imported "SH"."SALES":"SALES_Q1_1998" 2.314 MB 71805 rows . . imported "SH"."SALES":"SALES_Q2_1998" 2.344 MB 72705 rows . . imported "SH"."SALES":"SALES_Q3_1998" 2.051 MB 63390 rows . . imported "SH"."SALES":"SALES_Q3_1999" 2.453 MB 76139 rows . . imported "SH"."SALES":"SALES_Q4_2000" 2.413 MB 74736 rows . . imported "SH"."SALES":"SALES_1995" 0 KB 0 rows . . imported "SH"."SALES":"SALES_1996" 0 KB 0 rows . . imported "SH"."SALES":"SALES_H1_1997" 0 KB 0 rows . . imported "SH"."SALES":"SALES_H2_1997" 0 KB 0 rows Job "SYSTEM"."LOAD_HROLTP" completed with 2 error(s) at 16:38