Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can i know certain table created in which tablespace

Re: How can i know certain table created in which tablespace

From: Vincent Ventrone <vav_at_brandeis.edu>
Date: Thu, 2 Aug 2001 10:59:18 -0400
Message-ID: <9kbpmo$sl1$1@new-news.cc.brandeis.edu>

Try a simple query:

select tablespace_name from dba_tables where table_name='FOO' and owner='FOO_OWNER';

"Jordan" <mj_at_nba.com> wrote in message
news:9kbnsk$i6d2_at_imsp212.netvigator.com...
> How can i know certain table created in which tablespace
> THanks
>
>
Received on Thu Aug 02 2001 - 09:59:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US