Home » RDBMS Server » Server Administration » Creating TableSpace (Unix,Ora10G R2)
Creating TableSpace [message #338178] Mon, 04 August 2008 01:56 Go to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
Hi,

When i am running the following query to create a tablespace, i am getting the following error. Is something wrong?

CREATE TABLESPACE AREBDV_TS
DATAFILE '/ORCL/rxdb/oradata/arebdv_ts1.dbf' SIZE 5G REUSE 
, '/ORCL1/rxdb/oradata/arebdv_ts2.dbf' SIZE 5G REUSE 
, '/ORCL2/rxdb/oradata/arebdv_ts3.dbf' SIZE 5G REUSE 
AUTOEXTEND ON NEXT 16M
 MAXSIZE 38G
EXTENT MANAGEMENT LOCAL
 uniform size  64K
 ONLINE;


Error

ORA-03206: maximum file size of (string) blocks in AUTOEXTEND clause is out of range
Re: Creating TableSpace [message #338218 is a reply to message #338178] Mon, 04 August 2008 04:14 Go to previous message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
Found what was wrong, i had to give a MAX size of less than 32 GB, while i was using 38 GB in my scripts.
Previous Topic: Identify semaphore id in oracle 10g
Next Topic: Moving objects to a new tablespace
Goto Forum:
  


Current Time: Mon Jul 08 14:50:37 CDT 2024