Oracle of the Cloud Blogs

Your source of Cloud Based DBA tips and information.

06
May

ORA-03206: maximum file size of (4194304) blocks in AUTOEXTEND clause is out of range

Posted by on in Oracle
  • Font size: Larger Smaller
  • Hits: 36166
  • 0 Comments
  • Print

Problem:

When I tried to use this command:

ALTER DATABASE TEMPFILE '/d02/oradata/clouddba/temp2_01.dbf' AUTOEXTEND ON NEXT 5M MAXSIZE 32G

I got this error:


ERROR at line 1:
ORA-03206: maximum file size of (4194304) blocks in AUTOEXTEND clause is out of range

 

The fix I used (though not perfect) is the command below:
 

SQL> ALTER DATABASE TEMPFILE '/d02/oradata/clouddba/temp2_01.dbf' AUTOEXTEND ON NEXT 5M MAXSIZE 30G;
Database altered.

 

 

Rate this blog entry:
0
Tagged in: Oracle

Comments