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!

Export table without data and with data

user11432758Feb 13 2014 — edited Feb 15 2014

Would like to ask folks here, I want to export all db objects from schema to dmp file, noticed that this could be done via exp or expdp command. My Question is I want to export certain table's data only. example I've 100 tables in my schema and only got 10 table's data that required to export while the rest 90 tables I just want metadata only. How could I achieved that ? Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2014

Added on Feb 13 2014

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

8 comments

10,047 views