Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Drop unused Column

Re: Drop unused Column

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Thu, 4 Aug 2005 09:22:12 -0500
Message-ID: <de807caa050804072217f59f8c@mail.gmail.com>


Ken,
 My guess is that the Oracle kernel is slogging away. You could bounce the instance, but you might end up wrecking something worse. I think the moral to the story is to be extremely careful what commands you issue in production and any command you aren't entirely comfortable with, issue it on test first. Another alternative would have been to issue the "set unused" parameter on this command. Hang in there.  Dennis Williams

 On 8/3/05, Ken Payton <ken.payton_at_choicepointprg.net> wrote:
>
> It's gone, in fact the DBA has issued the the alter table drop columns
> continue command. It is currently running. Unfortunately, the table is
> not accessible during this time.
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 04 2005 - 09:24:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US