2 Replies Latest reply on Jul 6, 2020 3:55 AM by David Duenas

    Export tables with Primary Key index only excluding the statistics

    3709198

      Hello ,

       

      Please share how to export specific tables along with their Primary Key index only, excluding the statistics.

      The environment is Oracle 12cR2.

       

      Sample:

       

      USERID=system/kd98#2s@db011

      DIRECTORY=EXPDP_DIR

      CONTENT=DATA_ONLY

      LOGFILE=db011_export_20200601.log

      DUMPFILE=db011_export_20200601_%U.dmp

      COMPRESSION=ALL

      PARALLEL=4

      CLUSTER=N

      VERSION=12.1.0.2

      EXCLUDE=STATISTICS

      EXCLUDE=INDEX

      TABLES=USER.TBL_ALRT,

      USER.TBL_AUTH,

      USER.TBL_BUD,

      USER.TBL_ACH_DRE_KS,

      USER.TBL_BCH_DRE_INVENT