Database Administration (MOSC)

MOSC Banner

long running "alter table x drop unused columns checkpoint 10000;"

edited Nov 16, 2012 5:04AM in Database Administration (MOSC) 17 commentsAnswered
Hello,
I have a "alter table x drop unused columns checkpoint 10000;" running for the past 12 days. There is only one unused column in that table that is being dropped. The table has more than 14,725,000,000 records and according to dba_segments, is taking some 782 GB of storage (excluding indexes). Is there any way of knowing how far along the drop is or how many records are left to process?

Thank you,

Mark T.

P.S. Three days ago my desktop PC crashed and the drop column command got interrupted. So I resumed the operation with "alter table x drop columns continue;". I'm pretty sure that has no effect on the time it takes for the operation to complete (the documentation states "Specify 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center