Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: While I was dropping UNIQUE constraints on the table, I killed my process
Jay wrote:
>I was using SQL plus but it was hung for a about 20 min.
>So I killed kill the SQL plus using window task manager.
>
>Now.
>If I "desc table", it hangs.
>No, I'm not dropping table.
>
>
>Thanks.
>-Jay
>
>
>"Anurag Varma" <avarmadba.skipthis_at_yahoo.com> wrote in message
>news:qWVkb.7914$Fc5.1839_at_nwrdny01.gnilink.net...
>
>
>>"Jay" <no_at_spam.com> wrote in message
>>
>>
>news:bn19ds$5be$1_at_msunews.cl.msu.edu...
>
>
>>>While I was dropping UNIQUE constraints on the table, I killed my
>>>
>>>
>process.
>
>
>>>Now, I can not even "desc table". all other table is fine though.
>>>
>>>Is Oracle still dropping constraints?
>>>Or rolling back dropping ?
>>>Or crashed?
>>>
>>>Is there anyway I can check?
>>>
>>>
>>>Please help.
>>>-Jay
>>>
>>>
>>>
>>>
>>Are you getting any error while doing desc table?
>>How were you dropping the constraints (which tool?)?
>>If you were running a script .. did the script include dropping table
>>
>>
>also?
>
>
>>How did you kill your session?
>>
>>Drop comands are usually quick ... I don't understand why you had to kill
>>the session ...
>>
>>Post more info!
>>
>>Anurag
>>
>>
>>
>>
Is this a production database? What version and edition on what
hardware? Local or remote to the
SQL*Plus client?
My initial instinct is to bounce the database and query user_constraints.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Mon Oct 20 2003 - 13:56:41 CDT