autoextend user tablespace or add datafile
490768Jun 14 2007 — edited Jun 14 2007Hello,
My USERS tablespace had problem today when loading a file using sqlldr. It stopped loading halfway through the file.
The allocated is set to 1900 mb and the used was at 1850. I only have 1 datafile for users tablespace. I have autoextensible to YES.
Why did it not extend the tablespace when I should still have 2gb free??
I dropped a couple unused user tables and it reduced the used amount, then I was able reran the sqlldr load and it completed.
Should I create a new datafile
ALTER TABLESPACE USERS ADD DATAFILE ‘/usr/lib/oracle/xe/oradata/XE/users01.dbf’ SIZE 2000M AUTOEXTEND OFF;
or increase the allocation
ALTER DATABASE DATAFILE ‘/usr/lib/oracle/xe/oradata/XE/users.dbf’ RESIZE 3000M;
Thanks for the help...