Error adding datafile to tablespace: ORA-03206: maximum file size of (4194304) blocks in AUTOEXTEND clause is out of range
Steps to replicate error:
a) Go to Schema Browser |Tablespace | click TEMP tablespace | click “Alter selected tablespace” | Temp Files tab | clicked “Add”
b) Filled out the fields:
a. Tempfile Name: D:\ORACLE\PRODUCT\10.2.0\ORADATA\GUAPS\USERS02.DBF
b. Tempfile size: 1 MB
c. Auto Extend: Yes
d. Additional space…: 10 MB
e. Maximum size: 32 GB
c) Click OK, then OK, it will get the error:
ORA-03214: File Size specified is smaller than minimum required
d) pulled the SQL generated via “Show SQL” and pasted it in Editor.
ALTER TABLESPACE USERS ADD DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\GUAPS\USERS02.DBF'
SIZE 1024M AUTOEXTEND ON NEXT 10M MAXSIZE 32768M;
e) Run it in SQL Editor and will get the error:
ALTER TABLESPACE USERS ADD DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\GUAPS\USERS02.DBF'
SIZE 1024M AUTOEXTEND ON NEXT 10M MAXSIZE 32768M
Error at line 1
ORA-03206: maximum file size of (4194304) blocks in AUTOEXTEND clause is out of range
Script Terminated on line 1.
f) SQL Plus produces the same error.
g) If the MAXSIZE value in the script to “32767M”, it works.
