Monday, March 12, 2012

Error in adding datafile to users tablespace

alter tablespace users add datafile '/opt/oracle/app/oradata/aarav/users02.dbf' size 16G autoextend on next 1G maxsize 32G

Error report: SQL Error: ORA-03206: maximum file size of (4194304) blocks in AUTOEXTEND clause is out of range 03206. 00000 - "maximum file size of (%s) blocks in AUTOEXTEND clause is out of range" *Cause: The maximum file size for an autoextendable file has exceeded the maximum number of blocks allowed. *Action: Reduce the size and retry.


I users01.dbf was at 32G so I could not create any more data segments in it so had to add a new datafile to the tablespace above. Got the error so I modified the statement to alter tablespace users add datafile '/opt/oracle/app/oradata/aarav/users02.dbf' size 16G autoextend on next 1G;

No comments:

Post a Comment

Followers

About Me

Torrance, CA, United States