| Delete LOB data from LOB segment [message #655901] |
Thu, 15 September 2016 14:53  |
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
|
Senior Member |
|
|
One of the LOB segments is occupying more space in the database. The application team has mentioned that they have deleted some of the data through the application. However after the table re-org and then the table shrink cascade, the size of the segment still remains the same.
Through the estimation of expdp we found that the table size remains the same. How can we delete the data of LOB segments from the DB?
The application team has requested to delete the data from the database.
|
|
|
|
|
|
| Re: Delete LOB data from LOB segment [message #655999 is a reply to message #655901] |
Mon, 19 September 2016 12:47  |
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
|
Senior Member |
|
|
The LOB segment size is 55 GB.
Query used to find the segment size
The LOB data size is 2 MB.
Query used to find the LOB data size
select sum(dbms_lob.getlength (<lob column name>)) from <table_name>;
We used to do the online re-org.
We did a shrink after the re-org using the below statement.
alter table <table name> modify lob(<lob column name>) (shrink space [cascade]);
There is nothing seen in DBA_RECYCLEBIN. As well, since the deletion was performed through application functionality, it issues an AUTO COMMIT;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
