Re: Which tablespace is the table in? newbie question
Date: 1996/01/04
Message-ID: <4cha45$q8_at_instasrv.admin>#1/1
The describe command will not show you the tablespace name.
Use sqlplus:
If you own the table do a select * from user_tables where table_name = 'XX';
If someone else owns the table you must have permission to the object and
then use select * from all_tables where owner = 'OWNER' and table_nme = 'XX';
If you are a dba issue the following query,
select * from dba_tables where owner = 'OWNER' and table_name = 'XX';
HTH
Michael Pruitt (mpruitt_at_pluto.cs.uah.edu) wrote:
: I need to find out which tablespace a certain table is located
: in. I've been told that I can describe the table to find out, but I'm
: not sure how to describe. Any help would be appreciated. Thanks.
:
: --
: mpruitt_at_cs.uah.edu
: Michael Pruitt
:
:
Received on Thu Jan 04 1996 - 00:00:00 CET