10.20.3.0. -- Tablespace creation with datafile of 100GB -- ORA-03206:
NatrajanFeb 23 2007 — edited Feb 23 2007Hi All,
Why I get this error and hot fix it? I'm just creating only 100GB datafile!!
Please help..
SQL> CREATE TABLESPACE <<NAME>> datafile '<<NAME WIHT PATH>>>
2 SIZE 1000m AUTOEXTEND ON NEXT 1000m MAXSIZE 100000m
3 SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE jmdprd_data datafile ' <<<NAME WITH PATH>>/'
*
ERROR at line 1:
ORA-03206: maximum file size of (12800000) blocks in AUTOEXTEND clause is out
of range
SQL>
SQL> spool off
not spooling currently
Thanks a lot
Natrajan