Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: alter table question
"Matthias Hoys" <idmwarpzone_NOSPAM__at_yahoo.com> wrote in message
news:434ff765$0$29099$ba620e4c_at_news.skynet.be...
>
> "Oxnard" <shankeypNO_SPAM_at_comcast.net> wrote in message
> news:5tKdnUxXG_czSNLeRVn-pA_at_comcast.com...
>> db version 9.2.0.7
>>
>> If I do statements like:
>>
>> alter table add column ...
>>
>> alter table drop column ..
>>
>> alter table whatever to a constraint
>>
>> what is a good way to see how far the alter table .... has progressed?
>>
>
> v$session_longops maybe ?
>
it does show the long operation but depending on the table there maybe more than one long operation done thus I still cannot really tell how long the alter table will take. Received on Wed Oct 26 2005 - 19:16:17 CDT