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;
Subscribe to:
Post Comments (Atom)
Followers
About Me
- reiki
- Torrance, CA, United States
No comments:
Post a Comment