OraFAQ Forum: Server Administration » Problem creation TABLESPACE

Home » RDBMS Server » Server Administration » Problem creation TABLESPACE (Oracle 10g, UNIX AIX Version 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem creation TABLESPACE [message #356079]

Wed, 29 October 2008 07:06

you98
Messages: 1
Registered: October 2008

Junior Member

Hello,
I work on UNIX / Oracle 10g, and I want to create a tablesSpaces using the following script:

CREATE TABLESPACE tbs_y DATAFILE
'/sgbd/tbs/tbs_y_1.dbf'  SIZE 200M reuse extent management LOCAL uniform size 100M MAXSIZE 2000M,
'/sgbd/tbs/tbs_y_2.dbf' SIZE   5M reuse extent management LOCAL uniform size 100M MAXSIZE 2000M
	NOLOGGING ONLINE PERMANENT;

but I receive the following message:
ORA-02180: invalid option for CREATE TABLESPACE
Can you help me please ?

Report message to a moderator

Re: Problem creation TABLESPACE [message #356082 is a reply to message #356079]

Wed, 29 October 2008 07:35

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> CREATE TABLESPACE tbs_y DATAFILE
  2  '/sgbd/tbs/tbs_y_1.dbf'  SIZE 200M reuse extent management LOCAL uniform size 100M MAXSIZE 2000M,
  3  '/sgbd/tbs/tbs_y_2.dbf' SIZE   5M reuse extent management LOCAL uniform size 100M MAXSIZE 2000M
  4   NOLOGGING ONLINE PERMANENT;
'/sgbd/tbs/tbs_y_1.dbf'  SIZE 200M reuse extent management LOCAL uniform size 100M MAXSIZE 2000M,
                                                                                   *
ERROR at line 2:
ORA-02180: invalid option for CREATE TABLESPACE

With SQL*Plus it is much better.
And with SQL Reference too, maybe some keywords are missing.

Regards
Michel

Report message to a moderator

Re: Problem creation TABLESPACE [message #356343 is a reply to message #356079]

Thu, 30 October 2008 07:27

abed24
Messages: 18
Registered: October 2006
Location: Jordan

Junior Member

"MAXSIZE" is used only after "AUTOEXTEND ON"

Report message to a moderator

Previous Topic:	ORA-03106: fatal two-task communication protocol error
Next Topic:	ORA-01482: unsupported character set in 10g with gather stats

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 01:53:47 CST 2024