RE: RE: create tablespace problem

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Wed, 22 Jan 2003 03:09:52 -0800
Message-ID: <F001.0053725B.20030122030952@fatcity.com>

('binary' encoding is not supported, stored as-is)

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

Received on Wed Jan 22 2003 - 05:09:52 CST