11 Replies Latest reply: May 10, 2012 7:51 AM by Dean Gagne-Oracle RSS

    Import only structure and not the data.


      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.