Dear All,
OS - Windows
Database- 10.2.0.1
Here, I want to truncate the table which has BLOB Field but while checking the size of the segment(segment type=Table), shows only 7 MB. Though blob segment itself has 45 GB.
I need your assistance to re-claim the sizes at OS level though this table (linked with blob field) after truncation of table. Or can share any link about the Truncation of table (included blob entry).
Since this is testing database and without LAN connection, I am not able to provide you the data of it.
Regards,
Ashish Kumar Mahanta