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.
David Knight OCP DBA 8i, 9i, 10g
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
Forum Rules