Re: Newbie need help: how can I find out the extents used by a table?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 7 Dec 1999 09:30:38 +0100
Message-ID: <82igit$suac$1@oceanite.cybercable.fr>

You'll find that kind of information in views user_segments (or all_segments or dba_segments).

For example:
select substr(segment_name,1,15) name, tablespace_name, bytes, blocks, extents from user_segments where segment_name='USER_PROFILE';

NAME Tablespace BYTES BLOCKS EXTENTS --------------- --------------- ---------- ---------- ---------- USER_PROFILE SYSTEM 10240 5 1 1 row selected.

--
Have a nice day
Michel

hellen davis <hellen101_at_hotmail.com> a écrit dans le message : 384C9DB5.DCF8BA78_at_hotmail.com...
> Thanks a lot!
>
Received on Tue Dec 07 1999 - 02:30:38 CST