Re: table - extent - datafile

query dba_extents.
 the file_id can be obtained from dba_data_files

-Madhu S

"Uwe Schmidt" <uwe.schmidt_at_dzsh.de> wrote in message news:<newscache$tmbvwg$ni8$1_at_www-neu.dzsh.de>...
> 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
Received on Wed May 29 2002 - 12:18:00 CDT