Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can i know certain table created in which tablespace
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