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