ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/MYDB/users01.dbf'
AUTOEXTEND ON NEXT 1280K MAXSIZE 32GB
ORA-03206: maximum file size of (5242880) blocks in AUTOEXTEND clause is out of range
Here is reason: The maximum file size for an autoextendable file has exceeded the maximum number of blocks allowed.After research internet I found that instead of using 32GB we can use 32767M. (same values but in MB).
Or you may use 31GB too.
ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/MYDB/users01.dbf'
AUTOEXTEND ON NEXT 1280K MAXSIZE 32767M;
No comments:
Post a Comment