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!

Reducing USERS tablespace allocated size.

521763Jul 5 2006 — edited Jul 6 2006

Is there a way to reduce the size of the USERS database allocation. It is at 4.2 GBs and I have removed schemas and tables so that it is only using 14% of that space.

I have a database that I need to import that is using a couple of tablespaces that I need to set up.

I have tried compacting the database.

Any help would be greatly appreciated.
Mickey

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 3 2006

Added on Jul 5 2006

2 comments

653 views