请教oracle相关问题

Question

各位大神你们好，小弟刚刚走进oracle数据库的学习，现碰到一个问题，“怎样在oracle 11g数据库找到存放表空间的文件夹？”小弟找了很久，还是没有找到，自己新建了一个user和一个表空间，就是想找不到存放的文件夹。 菜鸟入门，还望各位赐教OracleOracle 11g数据库

Answer 1

如果你没改过默认是这样的目录里D:\app\user\oradata\orcl

Answer 2

我的是在这里E:\app\Luo\oradata\orcl

Answer 3

10:37:15 SYS@yktdadv > l
  1  select tablespace_name, file_name from dba_data_files
  2* order by tablespace_name, file_id
10:37:24 SYS@yktdadv > /TABLESPACE_NAME      FILE_NAME
-------------------- ----------------------------------------------------------------------
ADV_M01_TBS      /data/oraadv/oraadv_data/adv/adv_m01_tbs001.dbf
ADV_M01_TBS      /data/oraadv/oraadv_data/adv/adv_m01_tbs002.dbf
ADV_M01_TBS      /data/oraadv/oraadv_data/adv/adv_m01_tbs003.dbf
ADV_M01_TBS      /data/oraadv/oraadv_data/adv/adv_m01_tbs004.dbf
ADV_M02_TBS      /data/oraadv/oraadv_data/adv/adv_m02_tbs001.dbf
ADV_M02_TBS      /data/oraadv/oraadv_data/adv/adv_m02_tbs002.dbf
ADV_M02_TBS      /data/oraadv/oraadv_data/adv/adv_m02_tbs003.dbf
ADV_M02_TBS      /data/oraadv/oraadv_data/adv/adv_m02_tbs004.dbf
ADV_M03_TBS      /data/oraadv/oraadv_data/adv/adv_m03_tbs001.dbf
ADV_M03_TBS      /data/oraadv/oraadv_data/adv/adv_m03_tbs002.dbf
ADV_M03_TBS      /data/oraadv/oraadv_data/adv/adv_m03_tbs003.dbf
ADV_M03_TBS      /data/oraadv/oraadv_data/adv/adv_m03_tbs004.dbf
ADV_M04_TBS      /data/oraadv/oraadv_data/adv/adv_m04_tbs001.dbf
ADV_M04_TBS      /data/oraadv/oraadv_data/adv/adv_m04_tbs002.dbf
ADV_M04_TBS      /data/oraadv/oraadv_data/adv/adv_m04_tbs003.dbf
ADV_M04_TBS      /data/oraadv/oraadv_data/adv/adv_m04_tbs004.dbf
ADV_M05_TBS      /data/oraadv/oraadv_data/adv/adv_m05_tbs001.dbf
ADV_M05_TBS      /data/oraadv/oraadv_data/adv/adv_m05_tbs002.dbf
ADV_M05_TBS      /data/oraadv/oraadv_data/adv/adv_m05_tbs003.dbf
ADV_M05_TBS      /data/oraadv/oraadv_data/adv/adv_m05_tbs004.dbf
ADV_M06_TBS      /data/oraadv/oraadv_data/adv/adv_m06_tbs001.dbf
ADV_M06_TBS      /data/oraadv/oraadv_data/adv/adv_m06_tbs002.dbf
ADV_M06_TBS      /data/oraadv/oraadv_data/adv/adv_m06_tbs003.dbf
ADV_M06_TBS      /data/oraadv/oraadv_data/adv/adv_m06_tbs004.dbf
ADV_M07_TBS      /data/oraadv/oraadv_data/adv/adv_m07_tbs001.dbf
ADV_M07_TBS      /data/oraadv/oraadv_data/adv/adv_m07_tbs002.dbf
ADV_M07_TBS      /data/oraadv/oraadv_data/adv/adv_m07_tbs003.dbf
ADV_M07_TBS      /data/oraadv/oraadv_data/adv/adv_m07_tbs004.dbf
ADV_M08_TBS      /data/oraadv/oraadv_data/adv/adv_m08_tbs001.dbf
ADV_M08_TBS      /data/oraadv/oraadv_data/adv/adv_m08_tbs002.dbf
ADV_M08_TBS      /data/oraadv/oraadv_data/adv/adv_m08_tbs003.dbf
ADV_M08_TBS      /data/oraadv/oraadv_data/adv/adv_m08_tbs004.dbf
ADV_M09_TBS      /data/oraadv/oraadv_data/adv/adv_m09_tbs001.dbf
ADV_M09_TBS      /data/oraadv/oraadv_data/adv/adv_m09_tbs002.dbf
ADV_M09_TBS      /data/oraadv/oraadv_data/adv/adv_m09_tbs003.dbf
ADV_M09_TBS      /data/oraadv/oraadv_data/adv/adv_m09_tbs004.dbf
ADV_M10_TBS      /data/oraadv/oraadv_data/adv/adv_m10_tbs001.dbf
ADV_M10_TBS      /data/oraadv/oraadv_data/adv/adv_m10_tbs002.dbf
ADV_M10_TBS      /data/oraadv/oraadv_data/adv/adv_m10_tbs003.dbf
ADV_M10_TBS      /data/oraadv/oraadv_data/adv/adv_m10_tbs004.dbf
ADV_M10_TBS      /data/oraadv/oraadv_data/adv/adv_m10_tbs005.dbf
ADV_M11_TBS      /data/oraadv/oraadv_data/adv/adv_m11_tbs001.dbf
ADV_M11_TBS      /data/oraadv/oraadv_data/adv/adv_m11_tbs002.dbf
ADV_M11_TBS      /data/oraadv/oraadv_data/adv/adv_m11_tbs003.dbf
ADV_M11_TBS      /data/oraadv/oraadv_data/adv/adv_m11_tbs004.dbf
ADV_M12_TBS      /data/oraadv/oraadv_data/adv/adv_m12_tbs001.dbf
ADV_M12_TBS      /data/oraadv/oraadv_data/adv/adv_m12_tbs002.dbf
ADV_M12_TBS      /data/oraadv/oraadv_data/adv/adv_m12_tbs003.dbf
ADV_M12_TBS      /data/oraadv/oraadv_data/adv/adv_m12_tbs004.dbf
ADV_TBS       /data/oraadv/oraadv_data/adv/adv_tbs001.dbf
ADV_TBS       /data/oraadv/oraadv_data/adv/adv_tbs002.dbf
ADV_TBS       /data/oraadv/oraadv_data/adv/adv_tbs003.dbf
ADV_TBS       /data/oraadv/oraadv_data/adv/adv_tbs004.dbf
ADV_TBS       /data/oraadv/oraadv_data/adv/adv_tbs005.dbf
DEV1_BIPLATFORM      /data/oraadv/oraadv_data/yktdadv/DEV1_biplatform.dbf
DEV1_MDS      /data/oraadv/oraadv_data/yktdadv/DEV1_mds.dbf
DEV_BIPLATFORM      /data/oraadv/oraadv_data/yktdadv/dev_biplatform001.dbf
DEV_MDS       /data/oraadv/oraadv_data/yktdadv/dev_mds01.dbf
DIM_TBS       /data/oraadv/oraadv_data/dim/dim_tbs001.dbf
DIM_TBS       /data/oraadv/oraadv_data/dim/dim_tbs002.dbf
DIM_TBS       /data/oraadv/oraadv_data/dim/dim_tbs003.dbf
IND_BIEE_TBS      /data/oraadv/oraadv_data/adv/ind_biee_tbs001.dbf
LOG_TBS       /data/oraadv/oraadv_data/log/log_tbs001.dbf
ODS_TBS       /data/oraadv/oraadv_data/ods/ods_tbs001.dbf
SYSAUX      /data/oraadv/oraadv_data/yktdadv/sysaux01.dbf
SYSTEM      /data/oraadv/oraadv_data/yktdadv/system01.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_01.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_21.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_22.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_23.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_24.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_25.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_02.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_03.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_04.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_05.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_06.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_07.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_08.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_09.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_10.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_11.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_12.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_13.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_14.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_15.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_16.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_17.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_18.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_19.dbf
UNDOTBS1      /data/oraadv/oraadv_data/yktdadv/undotbs1_20.dbf
USERS      /data/oraadv/oraadv_data/yktdadv/users01.dbf
XMLDB_TS      /data/oraadv/oraadv_data/yktdadv/xmldb_ts.dbf93 rows selected.