查看表空间select * from dba_tablespaces;查看某个表属于哪个表空间或者表空间的数据表select owner, table_name, tablespace_name from dba_all_tables;自己写where条件
楼上正解 dba_tablespaces dba_all_tables 视图就可以了
dba_tablespaces dba_all_tables 是系统表么?
是系统表,还要用sys的权限登录进去才行····
1. select tablespace_name from dba_tablespaces2.select table_name,tablespace_name from dba_tables where table_name=UPPER('表名')3. select table_name,tablespace_name from dba_tables where tablespace_name=UPPER('表空间名字')
select * from user_tablespacesselect * from user_tables where table_name = ?select * from dba_tables where tablespace_name = ?
dba_tablespaces
dba_all_tables
视图就可以了
dba_all_tables 是系统表么?
select tablespace_name from dba_tablespaces2.select table_name,tablespace_name from dba_tables
where table_name=UPPER('表名')3.
select table_name,tablespace_name from dba_tables
where tablespace_name=UPPER('表空间名字')