RE: create tablespace problem

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';

> -----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: pomi
> INET: pomin_at_intouch.co.id
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sony kristanto
  INET: Sony_at_polyfincanggih.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).