Skip to Main Content
Forums

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!

Impdp table only

KSGNov 30 2012 — edited Nov 30 2012
Hi,

10.2.0.4 on Linux.

I have expdp of 10 schemas which has all objects included.
Now, I have to import those exported 10 schemas on a different database with tables and indexes only.

Solution: exclude=SEQUENCE,PROCEDURE,PACKAGE,TRIGGER,FUNCTION,SYNONYM,VIEW,TYPE (while doing impdp)

Thanks
KSG

Edited by: KSG on Nov 30, 2012 3:10 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2012
Added on Nov 30 2012
#database-key-features, #export-import-sql-loader-external-tables
3 comments
27,102 views