Home » SQL & PL/SQL » SQL & PL/SQL » ORA-02180: invalid option for CREATE TABLESPACE (Oracle 8i, Win XP SP3)
ORA-02180: invalid option for CREATE TABLESPACE [message #347750] Sat, 13 September 2008 12:22 Go to next message
satyam_r
Messages: 2
Registered: September 2008
Location: Mauritius
Junior Member

Hi everyone

I am getting the following message while creating tablespaces in Oracle 8i.
--------------------------------------------
Error on line 1
CREATE TABLESPACE v8main
LOGGING
DATAFILE 'c:\oracle\oradata\v8\v8main01.ora'

ORA-02180: invalid option for CREATE TABLESPACE
--------------------------------------------

I have checked on the net all the possibilities of this error and tried changing the sequence of the systax, etc... but with same result.

Can anyone help me please. Its urgent coz client is waiting for me.

The sql script that i run was:


drop tablespace v8main including contents;
CREATE TABLESPACE v8main
LOGGING
DATAFILE 'c:\oracle\oradata\v8\v8main01.ora' SIZE 1024M REUSE
AUTOEXTEND ON NEXT 1024M
MAXSIZE 10240M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;


drop tablespace v8conf including contents;
CREATE TABLESPACE v8conf
LOGGING
DATAFILE 'c:\oracle\oradata\v8\v8conf01.ora' SIZE 1024M REUSE
AUTOEXTEND ON NEXT 1024M
MAXSIZE 5120M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

drop tablespace v8large including contents;
CREATE TABLESPACE v8large
LOGGING
DATAFILE 'c:\oracle\oradata\v8\v8large01.ora' SIZE 1024M REUSE
AUTOEXTEND ON NEXT 1024M
MAXSIZE 10240M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

drop tablespace v8index including contents;
CREATE TABLESPACE v8index
LOGGING
DATAFILE 'c:\oracle\oradata\v8\v8index01.ora' SIZE 1024M REUSE
AUTOEXTEND ON NEXT 1024M
MAXSIZE 10240M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

drop tablespace v8temp including contents;
CREATE TEMPORARY TABLESPACE v8temp
TEMPFILE 'c:\oracle\oradata\v8\v8temp.ora' SIZE 300M REUSE
AUTOEXTEND ON NEXT 300M
MAXSIZE 5120M
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 1024K;

commit;
Re: ORA-02180: invalid option for CREATE TABLESPACE [message #347752 is a reply to message #347750] Sat, 13 September 2008 12:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please it is just a syntax error, read the SQL Reference, CREATE TABLESPACE.

In addition, if you use SQL*Plus, it will tell you what is the wrong option.

Regards
Michel
Re: ORA-02180: invalid option for CREATE TABLESPACE [message #347754 is a reply to message #347752] Sat, 13 September 2008 13:08 Go to previous messageGo to next message
satyam_r
Messages: 2
Registered: September 2008
Location: Mauritius
Junior Member

Thanks Michel, for your prompt reply. But the fact is that am almost new to Oracle, and have tried correcting the syntax, but with no avail. Since Friday i've been trying to make it work through correction of the syntax. I had used the same script for another client 3 weeks back and everything was fine, with no error messages, and the tablespaces were created successfully. If you could please help a little more by suggesting what is exactly wrong in it.

Thanks once more for your precious time and help.

Je te remercie infiniment Michel.

Satyam, de L'ile Maurice
Re: ORA-02180: invalid option for CREATE TABLESPACE [message #347755 is a reply to message #347754] Sat, 13 September 2008 13:14 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Two words for you to check out:
Version Differences.
Previous Topic: storing a image file in a table
Next Topic: SQL
Goto Forum:
  


Current Time: Sun Dec 04 02:34:14 CST 2016

Total time taken to generate the page: 0.07962 seconds