Re: How to drop the "DATA" tablespace?

You do realize that the xxx.dbf name has nothing to do with what the tablespace name is inside of Oracle. Your idea may be good, but it won't work.
As far dropping it, I seem to have gotten in here late, and need a little more info.

"dan whatley" <dan.whatley_at_motorola.com> wrote in message news:a04df3c3.0106180915.63d5868a_at_posting.google.com...
> cif_at_ms1.hinet.net (lawrence) wrote in message
 news:<3b2b2fca.267946_at_netnews.hinet.net>...
> > Dears,
> >
> > I had met a problem that is
> > I cann't drop the "DATA" tablespace(I had made another
> > tablespace just like "DATA_DAT" to instead of "DATA")?
> > I had tried to take it offline then copy(dd) it into xxx.dbf
> > then rename it into another xxx.dbf;
> > but when I want to take it online,
> > the Oracle won't let me bring it online!
> > what can I do?
> >
> > if anyone knew the answer,please tell me!
> >
> > Regards,
> > lawrence
> > 06/16/2001
>
> Hi Lawrence,
>
> What happens when you do an "alter tablespace data offline;" ?
> If that works, you can do an "drop tablespace data;"
> And then, remove the datafile "rm data.dbf" at the unix level.
> I am assuming that there is nothing in tablespace DATA that
> you don't want to save.
>
> Talk to you then,
>
> dan.whatley_at_motorola.com
> sr. oracle dba
Received on Sat Jul 07 2001 - 16:05:19 CEST