本文共 1104 字,大约阅读时间需要 3 分钟。
SQL> select ts#,name from v$tablespace; TS# NAME ---------- ------------------------------ 0 SYSTEM 1 UNDOTBS1 2 SYSAUX 4 USERS 3 TEMP 6 EXAMPLE 已选择6行。 |
SQL> select t.ts#,t.name,d.ts#,d.name from v$tablespace t,v$datafile d 2 where t.ts#=d.ts#; TS# NAME TS# NAME ---------- -------------------- ---------- -------------------- 0 SYSTEM 0 D:/ORACLE/ORADATA/OR AMGR/SYSTEM01.DBF 1 UNDOTBS1 1 D:/ORACLE/ORADATA/OR AMGR/UNDOTBS01.DBF 2 SYSAUX 2 D:/ORACLE/ORADATA/OR AMGR/SYSAUX01.DBF 4 USERS 4 D:/ORACLE/ORADATA/OR AMGR/USERS01.DBF TS# NAME TS# NAME ---------- -------------------- ---------- -------------------- 6 EXAMPLE 6 D:/ORACLE/ORADATA/OR AMGR/EXAMPLE01.DBF |
转载地址:http://gavdi.baihongyu.com/