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!

How to take backup of a database with only schemas in it?!!!!

3283400Jul 26 2016 — edited Jul 27 2016

hello everyone,

i want to take a database backup with only schemas in it without data is it possible?

im using oracle 11g version is 11.2.0

normally we take back up in this format expdp

"expdp system/jj@orcl full=Y directory=dump_dir dumpfile=yourdmpfilename.dmp logfile=yourlogfilename.log"

but this takes full backup of a database

but i want only schemas in a database is it possible?? can anyone help me out? is there any query for it? for taking backup of only schemas?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2016

Added on Jul 26 2016

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

12 comments

382 views