Dear firends,
I have got a table contains blob column (total size 900GB) , I would like to reorganize it by creating new table as partitioned table for best performance.
what is rapid way?
a- using parallel expdp ( query=\"where ID\>=... and ID\<=.... ) and using parallel impdp's into new partitioned table
......
b-using CTAS (into parttioned table)
create table new_table_lob_p ..... partition .....
INSERT /*+APPEND*/ into new_table_lob_p as select parallel(16) * from old_table_lob
regards