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