Hi
We are having a 10g database and I need to drop a coulumn of in which the table size around 320GB. The coloumn too is having huge data.
The table is partitioned and have an index which is too partitioned.
If just go ahead and drop directly the column, it will take several hours.
If I go ahead and put the column in UNUSED mode and then drop, still it will take several hours.
Is there any option to get this column drop so fast. If so whats the command and what steps I should do ?
Kindly let me know.
Thanks
SHIYAS M