Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora 3206

451469Oct 3 2005 — edited Oct 3 2005
I was trying to create the user tablespace and got the following error message :
ERROR at line 1:
ORA-03206: maximum file size of (16776704) blocks in AUTOEXTEND clause is out of range
Is anything in my initSID.ora file I have to change ?
I am using the default init.ora file.

From
P
$ more createusertsp.sql
CREATE TABLESPACE "USERS01"
LOGGING
DATAFILE '/dbms/gavdb/GAV/users_ts001f01.dbf' SIZE 38192K REUSE
AUTOEXTEND
ON NEXT 16384K MAXSIZE 32767M DEFAULT
STORAGE ( INITIAL 16K NEXT 8K MINEXTENTS 1 MAXEXTENTS 505
PCTINCREASE 0 );
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2005
Added on Oct 3 2005
4 comments
642 views