Home » RDBMS Server » Server Administration » Problem creation TABLESPACE (Oracle 10g, UNIX AIX Version 5.3)
Problem creation TABLESPACE [message #356079] Wed, 29 October 2008 07:06 Go to next message
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 ?
Re: Problem creation TABLESPACE [message #356082 is a reply to message #356079] Wed, 29 October 2008 07:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Problem creation TABLESPACE [message #356343 is a reply to message #356079] Thu, 30 October 2008 07:27 Go to previous message
abed24
Messages: 16
Registered: October 2006
Location: Jordan
Junior Member

"MAXSIZE" is used only after "AUTOEXTEND ON"
Previous Topic: ORA-03106: fatal two-task communication protocol error
Next Topic: ORA-01482: unsupported character set in 10g with gather stats
Goto Forum:
  


Current Time: Mon Dec 05 14:54:24 CST 2016

Total time taken to generate the page: 0.08657 seconds