I have a huge table having 5000 00 000 rows and 650 GB and having 2 fields as blob.
I tried a move in parallel mode, but did not work and took 48hours.
I tried a CTAS from the original table but took 36H without any results with both parallel and no parallel tests.
I tried to partition the table it took too much time(48H without any result).
I tried a CTAS as a partitioned tabke from the original table and took again too much time more than 24H.
Do yu have any idea konwing that the downtime I am authorized to for the application is arround 6H maximum.