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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > >> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
