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 to new other table

user13549752Aug 24 2012 — edited Aug 24 2012

DB:11.2.0.2

Hi, i want to impot one table AUDIT_EVENT from audit user to another table AUDIT_EVENT_OLD is there any option like REMAP_TABLE like in impdp in imp.

imp prbprb/xxxxx tables=audit.AUDIT_EVENT query=adtora.audit_event_repo:"where audited_db_name_qual_1 in ('encmppdal1','ecop1')" dumpfile=2012_04_ORA.dmp logfile=table_imp.log statistics=none ignore=y

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 21 2012

Added on Aug 24 2012

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

6 comments

184 views