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
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
>
>
Received on Mon Oct 20 2003 - 13:42:11 CDT