Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What does this log file shows about import of schema? Please give comments.

TAJDINJun 19 2015 — edited Jun 19 2015

Sir,

What does this log file shows about import of schema? Please give comments.

Master table "ASH"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded

Starting "ASH"."SYS_IMPORT_SCHEMA_01": 

Processing object type SCHEMA_EXPORT/USER

ORA-31684: Object type USER:"ASH" already exists

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/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

ORA-39120: Table "ASH"."CUSTOMER" can't be truncated, data will be skipped. Failing error is:

ORA-02266: unique/primary keys in table referenced by enabled foreign keys

ORA-00955: name is already used by an existing object

ORA-39120: Table "ASH"."PRODUCT" can't be truncated, data will be skipped. Failing error is:

ORA-02266: unique/primary keys in table referenced by enabled foreign keys

ORA-00955: name is already used by an existing object

ORA-39120: Table "ASH"."SUPPLIER" can't be truncated, data will be skipped. Failing error is:

ORA-02266: unique/primary keys in table referenced by enabled foreign keys

ORA-00955: name is already used by an existing object

ORA-39120: Table "ASH"."PURCHASE" can't be truncated, data will be skipped. Failing error is:

ORA-02266: unique/primary keys in table referenced by enabled foreign keys

ORA-00955: name is already used by an existing object

ORA-39120: Table "ASH"."SALES" can't be truncated, data will be skipped. Failing error is:

ORA-02266: unique/primary keys in table referenced by enabled foreign keys

ORA-00955: name is already used by an existing object

Table "ASH"."PURCHASELINE" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate

Table "ASH"."SALESLINE" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate

Table "ASH"."STOCK" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

. . imported "ASH"."PURCHASELINE"                        6.398 KB      12 rows

. . imported "ASH"."SALESLINE"                           6.546 KB      22 rows

. . imported "ASH"."STOCK"                               5.890 KB       7 rows

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

ORA-39112: Dependent object type INDEX:"ASH"."CUSTOMER_PK" skipped, base object type TABLE:"ASH"."CUSTOMER" creation failed

ORA-39112: Dependent object type INDEX:"ASH"."PRODUCT_PK" skipped, base object type TABLE:"ASH"."PRODUCT" creation failed

ORA-39112: Dependent object type INDEX:"ASH"."SUPPLIER_PK" skipped, base object type TABLE:"ASH"."SUPPLIER" creation failed

ORA-39112: Dependent object type INDEX:"ASH"."PURCHASE_PK" skipped, base object type TABLE:"ASH"."PURCHASE" creation failed

ORA-39112: Dependent object type INDEX:"ASH"."SALES_PK" skipped, base object type TABLE:"ASH"."SALES" creation failed

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

ORA-39112: Dependent object type CONSTRAINT:"ASH"."CUSTOMER_PK" skipped, base object type TABLE:"ASH"."CUSTOMER" creation failed

ORA-39112: Dependent object type CONSTRAINT:"ASH"."PRODUCT_PK" skipped, base object type TABLE:"ASH"."PRODUCT" creation failed

ORA-39112: Dependent object type CONSTRAINT:"ASH"."SUPPLIER_PK" skipped, base object type TABLE:"ASH"."SUPPLIER" creation failed

ORA-39112: Dependent object type CONSTRAINT:"ASH"."PURCHASE_PK" skipped, base object type TABLE:"ASH"."PURCHASE" creation failed

ORA-39112: Dependent object type CONSTRAINT:"ASH"."SALES_PK" skipped, base object type TABLE:"ASH"."SALES" creation failed

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"ASH"."CUSTOMER_PK" creation failed

ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"ASH"."PRODUCT_PK" creation failed

ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"ASH"."SUPPLIER_PK" creation failed

ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"ASH"."PURCHASE_PK" creation failed

ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"ASH"."SALES_PK" creation failed

Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE

Regards

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2015
Added on Jun 19 2015
22 comments
3,755 views