Re: How to see where tables are stored

The table could exist in more than one file (assuming a tablespace occupies more than 1 file.) so a table could occupy more than one raw device. The rowid has the file number as part of it. I believe it is fileid.block in the file.row in block (pre Oracle 8). So you could do something like:

select funct_converts_row_id_to_just_file_id(rowid) from MyTable group by funct_converts_row_id_to_just_file_id(rowid); "Greg" <n_at_kman.dk> wrote in message
news:vxEQ5.377$e67.18567_at_news.get2net.dk...
> Hi gurus
>
>
> Can anybody tell me how I can see excatly where a specific table is
 stored?
>
> I have a 7.3.2 db stored on raw-devices, and some of the tablespaces are
> stored on more than one raw-device. Now I can seee that some of the
> raw-devices are heavily used, but I want to know excatly which table is
> accessed. How can I tell? I know that I can see the connections between
> raw-devices and tablespaces in dba_data_files, but the connection between
> tables and raw-devices?
>
>
> Thanks in advance
> Greg
>
>
Received on Thu Nov 16 2000 - 03:26:02 CET