Oracle Database Discussions

Hi I have an existing DB setup with an undotbs set to 51200M

DB Create script has a line as follows:
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u02/app/oracle/oradata/mydb/undotbs01.dbf' SIZE 1024M REUSE AUTOEXTEN
D ON NEXT 1024M MAXSIZE 51200M

I need to re-size the redo log to 64 gigs and when I try the following I get an error:

SQL> ALTER DATABASE DATAFILE '/u02/app/oracle/oradata/mydb/undotbs01.dbf' AUTOEXTEND ON MAXSIZE 65536M;
ALTER DATABASE DATAFILE '/u02/app/oracle/oradata/mydb/undotbs01.dbf' AUTOEXTEND ON MAXSIZE 65536M
*
ERROR at line 1:
ORA-03206: maximum file size of (4194304) blocks in AUTOEXTEND clause is out of
range

--------------------------------------------------------------------------------------------------------------------------

However if I set it to unlimited which I believe is equivalent from a space standpoint it works. (16k blocks so 64gig max)

SQL> ALTER DATABASE DATAFILE '/u02/app/oracle/oradata/mydb/undotbs01.dbf' AUTOEXTEND ON MAXSIZE UNLIMITED;

Database altered.



--------------------------------------------------------------------------------------------------------------------------

Was wondering if the two commands are not equivalent somehow and if someone can explain the cause for the error?

I came up with 65536 megs by doing 64 * 1024.

Thanks,

Jared