0 Replies Latest reply: Oct 24, 2013 4:52 AM by 912bce5a-bd95-4c37-8a02-9f4c0afe31e5 RSS

    expdp table  with grants indexes constraints etc

    912bce5a-bd95-4c37-8a02-9f4c0afe31e5

      hi

      i need to export table/sometime table partitions including grants, constraints, indexes

       

      this is what im using..

       

      expdp   parfile=par.exp directory=expdir dumpfile=exp1.dmp tables=hr.employee

      parfile.exp is:

      userid="/ as sysdba"

      JOB_NAME=dbajob

       

      do i need to include more options?

       

      thanks in advance