Re: table - extent - datafile

On Wed, 29 May 2002 12:31:15 +0200, "Uwe Schmidt" <uwe.schmidt_at_dzsh.de> wrote:

>Hey Newsgroup,
>
>
>how can I see with an SQL statement where my table extents are located;
>means in which datafile are they located - specially when the table is
>located over more than 1 datafile. I would like to reszie a spezial datafile
>and want therefore to know, where the extents of my tables are located.
>
>
>Thanks
>Uwe Schmidt
>

select * from dba_extents where owner = ... etc

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed May 29 2002 - 09:54:05 CDT