Skip to Main Content

Oracle Database Discussions

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!

How can I estimate the remaining time of operation of 'alter table drop columns continue'?

3153228May 10 2016 — edited May 13 2016

Hi guys,

     I execute 'alter table drop columns continue' of a table which has 3 billion rows, and now I want to know the remaining time of the sql.

     The v$session_longops does not work.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2016
Added on May 10 2016
14 comments
3,262 views