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
"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
Jordan,
Try this:
select table_name, tablespace_name
from all_tables
where table_name = '.....'
Substitute the actual table name for the '.....'; you'll see the tablespace where the table has been created.
David Fitzjarrell Received on Thu Aug 02 2001 - 16:16:27 CDT