Database Administration (MOSC)

MOSC Banner

what happen to the free blocks when we delete data from a table ?

edited Nov 25, 2017 4:01AM in Database Administration (MOSC) 8 commentsAnswered

Hi Experts,

I have deleted around 100GB of LOB files from a table. but still getting error to extend the tablespace. Do the free space reused by the table ?

How can I reuse the free space by the same table?

My DB Version is: 11.2.0.3 - SE1

OS: Windows 2008R2

Tablespace Type: BIGFILE (All LOBs of the schema are stored in this tablesapce)

recycle bin is also empty.

SQL> select count(*) from dba_recyclebin;

COUNT(*)

----------

0

Please help with some advise.

Thank You.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center