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!

Imp full db successful with warnings

DBA2011Apr 4 2012 — edited Apr 4 2012

Looking for options to fix those , or can i ignore them? What would be side effect if i drop/cascade users and re-run imp after increasing tablespace TS_PUBLIC size or i should not do that? and just fix the little warnings or even just ignore them?

Most of tables (i would say 95% ) & there data imported successfully after full imp , db size is 80GB around, import terminated successfully with warnings , which are below.....

IMP-00017: following statement failed with ORACLE error 1659:
"CREATE TABLE "CA_QUERY_1"
"ABLESPACE "TS_PUBLIC""

IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "ADMIN"."CHECK_EXTENTS_V"

IMP-00041: Warning: object created with compilation warnings
"CREATE TRIGGER MT1758.MEDDRA_MT1758_THE_SYN_UPD"

This post has been answered by sb92075 on Apr 4 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 2 2012

Added on Apr 4 2012

#database-key-features, #export-import-sql-loader-external-tables

4 comments

1,765 views