Re: Database partitioning

Posted by ErmanArslansOracleBlog on Jun 07, 2022; 3:03pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Database-partitioning-tp10937p10938.html

Normally, we have 5 general methods to convert a nonpartitioned table to a partitioned one;

A) Export/import method
B) Insert with a subquery method
C) Partition exchange method
D) DBMS_REDEFINITION
E) MODIFY clause added to the ALTER TABLE SQL Statement. (From 12.2)

Check -> How to Partition a Non-partitioned / Regular / Normal Table (Doc ID 1070693.6)

That slowness should be analyzed in the right context, but did you check the following MOS note? There are lots of issue reported there ->

DataPump Import (IMPDP) Performance Known Problems (Doc ID 1948188.1)

Also, as an alternative; did you check the ONLINE REDEFINITION?

AN EXAMPLE OF A COMPLEX ONLINE TABLE REDEFINITION (DBMS_REDEFINITION) (Doc ID 1358236.1)