SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dropping a column in a table with 1 billion records

DBQuestJan 7 2020 — edited Jan 7 2020

Hi,

I have recently added a column STATUS_CODE VARCHAR2(50) to REV_TRANSACTIONS table which is having 1 billion records.

I did testing, Data around 50K records also populated into STATUS_CODE column.

I want to drop the STATUS_CODE column now, when i run following statement it is taking very long time running since last 15 mins.

ALTER TABLE REV_TRANSACTIONS DROP COLUMN STATUS_CODE;

Please advise the way to drop column in shorter time.

Thanks,

Added on Jan 7 2020

4 comments

5,772 views