Oracle查找表属于哪个表空间
SELECT TABLE_NAME,TABLESPACE_NAME FROM DBA_TABLES
where TABLE_NAME = '表名';
SELECT TABLE_NAME,TABLESPACE_NAME FROM user_TABLES
where TABLE_NAME = '表名';
SELECT TABLE_NAME,TABLESPACE_NAME FROM DBA_TABLES
where TABLE_NAME = '表名';
SELECT TABLE_NAME,TABLESPACE_NAME FROM user_TABLES
where TABLE_NAME = '表名';