1 Reply Latest reply on Jun 7, 2017 5:07 PM by BhaskarKoniki

    export dump - need only table data

    JimT

      I am exporting data from a table based on some criteria. But it is exporting all the related objects like grants, indexes, stats..etc.  But the requirement is to export only table data.

       

      Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

      Total estimation using BLOCKS method: 21.58 GB

      Processing object type TABLE_EXPORT/TABLE/TABLE

      Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

      Processing object type TABLE_EXPORT/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT

      Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

      Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

      Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

      . . exported "ONT"."OE_ORDER_LINES_ALL"                  71.71 MB  107712 rows

      Master table "ONT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded