<<Back to Oracle DATAPUMP Main Page Converting Partition Table to non Partitioned using impdp PARTITION_OPTIONS is an impdp parameter used to convert partitioned tables in non-partitioned one while importing. Allowed values for PARTITION_OPTIONS parameter are NONE – This is the default value. Table imported as its in export. DEPARTITION – Promotes each partition or subpartition to a new individual table. The default name of the new table will be the concatenation of the table and partition name or the table and subpartition name, as appropriate. MERGE – Combines all partitions and subpartitions into one table. $ cat imp.par DIRECTORY=EXP DUMPFILE=EXP.DMP LOGFILE=IMP.LOG PARTITION_OPTIONS=MERGE $impdp system@PDB02 parfile=imp.par
A Blog to share interesting Database Facts and Experience.