>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).