Re: alter table question

"Oxnard" <shankeypNO_SPAM_at_comcast.net> wrote:

>
>"Turkbear" <john.g_at_dot.spamfree.com> wrote in message
>news:avmvk1damhni12ejq15it6fnvh0rkfpek1_at_4ax.com...
>> "Oxnard" <shankeypNO_SPAM_at_comcast.net> wrote:
>>
>>>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?
>>>
>>
>> Progressed how?
>> Using what tool to execute those statements?
>>
>>
>>
>
>Progress as in % completed.
>any tool like toad or sql+ OEM
>

No % will be shown - It will just say 'table altered' when done.

Many will be done immediately , but adding constraints, for example, can take a lot of time for a large table.. Received on Fri Oct 14 2005 - 12:17:15 CDT