How do I determine what extent my tablespace is currently on?
Printable View
How do I determine what extent my tablespace is currently on?
If you have DBA Studio, look at the properties of the table.
Otherwise you can try looking at DBA_SEGMENTS or DBA_TABLES.
Good luck.
well you probably really mean "What blocks is my tablespace using" Extents forms segments, segments tablespace, in other words you can have duplicate extent id in a tablespace whereas block id is unique