1 Reply Latest reply on Dec 10, 2012 4:19 PM by Richard Harrison .

    export table partition

    R. Royal
      I need export many partition (more 1000)

      export datapump use:
      TABLES=[schema_name.]table_name[:p1],[schema_name.]table_name[:p2],[schema_name.]table_name[:p2] [, ...:p1000]
      BUT I'd like to use query on DBA_TAB_PARTITIONS or USER_TAB_PARTITIONS.

      Can I use a query into TABLES parameter or INCLUDE parameter for table partition?

      Thanks in advence!
        • 1. Re: export table partition
          Richard Harrison .
          Looks like it might only be possible through the plsql API - see an example here:


          The other approach may be to have a query setting that selects the partitions you want (essentially repeat the partition clause in the query - easy for list partitioning for example....)