Oracle Database Discussions

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!

Exporting all schemas MetaData

534640Nov 25 2006 — edited Nov 26 2006

Hi,
Can any one tell me how to export all schemas metadata only. I have some partitioned tables/indexes and have 700+ tablespaces. I am using Oracle 10g.
I have used this statement for export. Is this correct?
expdp directory=dumps dumpfile=oraedwp_fkhalid.dmp logfile=oraedwp_fkhalid.log schemas=FKHALID,scott,hr content=METADATA_ONLY

And what is the statement to import this on another database.
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2006

Added on Nov 25 2006

#general-database-discussions

3 comments

1,048 views