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!

Import only structure and not the data.

840849Feb 24 2011 — edited May 10 2012
Hi,


I want to create a new user(A) which should have the same structure as an existing schema(B).
I have taken an export backup of the full schema(along with the data) using expdp as:

expdp system/xxxx directory=EXPDP dumpfile=A.dmp logfile=A.log SCHEMAS=A parallel=2

How can i create a new user (say B) with only the structure of schema A and not the data, using impdp???

Thanks in Advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2012
Added on Feb 24 2011
#11g, #database-key-features, #export-import-sql-loader-external-tables
11 comments
16,169 views