From: "Robert Fazio" Newsgroups: comp.databases.oracle References: <3b2b2fca.267946@netnews.hinet.net> Subject: Re: How to drop the "DATA" tablespace? Lines: 41 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: Date: Sat, 07 Jul 2001 14:05:19 GMT NNTP-Posting-Host: 24.8.218.197 X-Complaints-To: abuse@home.net X-Trace: news1.rdc2.pa.home.com 994514719 24.8.218.197 (Sat, 07 Jul 2001 07:05:19 PDT) NNTP-Posting-Date: Sat, 07 Jul 2001 07:05:19 PDT Organization: Excite@Home - The Leader in Broadband http://home.com/faster 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" wrote in message news:a04df3c3.0106180915.63d5868a@posting.google.com... > cif@ms1.hinet.net (lawrence) wrote in message news:<3b2b2fca.267946@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@motorola.com > sr. oracle dba