Re: How to see where tables are stored

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Thu, 16 Nov 2000 18:04:40 GMT
Message-ID: <8v17jj$nbj$1@nnrp1.deja.com>

select tablespace_name
from sys.dba_segments
where segment_name = 'MYTABLE'
and owner = 'MYSELF'

This query will give you all tablespaces for the table MYTABLE which belongs to user MYSELF. rowid will give you more info, including file and block number. For example

select rowid
from mytable

In article <vxEQ5.377$e67.18567_at_news.get2net.dk>, "Greg" <n_at_kman.dk> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 16 2000 - 12:04:40 CST