Re: alter table question

"Turkbear" <john.g_at_dot.spamfree.com> wrote in message news:grpvk19kcv0tt34nhc7al3q9j5bg2p3abe_at_4ax.com...
> "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..
>
>

I know it will say 'table altered' when done. What I am looking for is what dictionary tables I can look at to get a clue as to as to how far the alter table has progressed. Received on Fri Oct 14 2005 - 12:22:01 CDT