Hi All,
I have a huge table with 380 columns. It contains around 1 million records.
I am trying to drop 120 columns from this table using
alter table tab1 drop ( col1, col2, col3.
.
col120
);
This drop statement has been running since last 2hrs. I thought drop operation would not take so much of time.
I am using oracle 11g Rel2. What is the proper why to drop these many columns from a large table.
Thanks in advance.