This discussion is archived
11 Replies Latest reply: May 10, 2012 5:51 AM by Dean Gagne RSS

Import only structure and not the data.

840849 Newbie
Currently Being Moderated

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.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points