in 9i, you can remove the datafiles as well by using the clause "and
datafiles" on the drop tablespace command.
Saves having to remember to go back and clean up after yourself.
Without that clause, the drop tablespace command works as it did in 8i
Rachel
- Stephane Faroult <sfaroult_at_oriolecorp.com> wrote:
>
> >Pomin,
> >
> >Pls check this tablespace whether it's already
> >exist in your database.
> >Try this script (connect as sys):
> >
> >SQL > select * from dba_tablespaces where
> >tablespace_name = 'TSelCZ_Data';
>
> Would be better in UPPERCASE. Besides, this is far from being enough.
> When you drop a tablespace, the files subside (Hmm, I think that it
> is not necessarily still true with Oracle9 ... need to RTFM) and
> should (assuming a version which etc. etc.) be removed by hand. File
> existence prevents you from creating a new one with the same name.
> The tablespace no longer appears in DBA_TABLESPACES (version
> dependent ?) but still lurks in sys.ts$.
> Of course you can use REUSE but this is a great way to wipe out an
> existing, useful tablespace by mistake.
>
> >> -----Original Message-----
> >> From: pomin [SMTP:pomin_at_intouch.co.id]
> >> Sent: Wednesday, January 22, 2003 1:54 PM
> >> To: Multiple recipients of list ORACLE-L
> >> Subject: create tablespace problem
> >>
> >> I'm have problem when execute this script, the
> >error is show by oracle is
> >> "error at line 1
> >> ORA-.......:TSelCZ_Data already exists;
> >>
> >>
> >> -- create tablespace
> >>
> >> CREATE TABLESPACE TSelCZ_Data DATAFILE
> >'d:\orant\database\tselcz1dbCZ.ora'
> >>
> >> SIZE 150M;
> >> ALTER TABLESPACE "TSELCZ_DATA" DEFAULT STORAGE (
> >MAXEXTENTS UNLIMITED );
> >> /
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephane Faroul
> INET: sfaroult_at_oriolecorp.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Jan 22 2003 - 06:53:42 CST
