Hi,
I have thousands of tables that do not have Extents nor Segments.
Here are my queries :
Query to find tables : SELECT table_name FROM all_tables WHERE table_name LIKE 'KEYSET%' (this gives me some thousands records / tables)
To find segments : select segment_name,segment_type, bytes from dba_segments WHERE segment_name LIKE 'KEYSET%' (gives me 28 records)
To find extents : select segment_name,segment_type, bytes from dba_extents WHERE segment_name LIKE 'KEYSET% (gives me 28 records)
Questions are :
The segments_name in both extent are not exactly the same. Why ?
Why many many tables do not have segments nor extents ? I thought if a table exists, it must have been allocated an extent / segment
BTW, i want to delete those unused keyset tables and then reclaim the space. I just need to see the after and before the deletion happens in term of space.
Need your enlightment. Please.
Ps : I am not a dba.
Thanks