Re: Drop unused Column
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: oracledba.williams@xxxxxxxxx, ken.payton@xxxxxxxxxxxxxxxxxx
- Date: Thu, 4 Aug 2005 08:40:43 -0700 (PDT)
For tables this large, you could probably use
dbms_redef, where you could create a new table w/o the
unwanted column, and do the task online.
Thanks,
Deepak
--- Dennis Williams <oracledba.williams@xxxxxxxxx>
wrote:
> 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@xxxxxxxxxxxxxxxxxx> 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.
> >
> >
> >
>
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
--
//www.freelists.org/webpage/oracle-l
Other related posts:
