Re: Drop unused Column

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Thu, 4 Aug 2005 08:40:43 -0700 (PDT)
Message-ID: <20050804154043.87970.qmail@web52802.mail.yahoo.com>

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_at_gmail.com> 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_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.
> >
> >
> >
>
                

---

Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs  

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 04 2005 - 10:42:55 CDT