Skip to Main Content

Oracle Database Discussions

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!

Tablespace full, mostly due to recyclebin

mtefftJul 9 2012 — edited Jul 9 2012
We have a tablespace that has become full (ORA-01653: unable to extend table xxx by 64 in tablespace ODI_WORK)

There is about 24GB of recycle-bin objects in that tablespace.
According to the Database Administrators Guide (http://docs.oracle.com/cd/E11882_01/server.112/e25494/tables011.htm#sthref2311) says:
Dropped tables and any associated objects such as indexes, constraints, nested tables, and the likes are not removed and still occupy space. They continue to count against user space quotas, until specifically purged from the recycle bin or the unlikely situation where they must be purged by the database because of tablespace space constraints.

So, we have apparently reached the space constraints; why were the objects not purged?

select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Solaris: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

5 rows selected.

Thanks,
Mike
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2012
Added on Jul 9 2012
3 comments
615 views