Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

autoextend user tablespace or add datafile

490768Jun 14 2007 — edited Jun 14 2007

Hello,

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...

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 12 2007

Added on Jun 14 2007

1 comment

1,584 views