请教oracle相关问题 各位大神你们好,小弟刚刚走进oracle数据库的学习,现碰到一个问题,“怎样在oracle 11g数据库找到存放表空间的文件夹?”小弟找了很久,还是没有找到,自己新建了一个user和一个表空间,就是想找不到存放的文件夹。 菜鸟入门,还望各位赐教OracleOracle 11g数据库 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 如果你没改过默认是这样的目录里D:\app\user\oradata\orcl 我的是在这里E:\app\Luo\oradata\orcl 10:37:15 SYS@yktdadv > l 1 select tablespace_name, file_name from dba_data_files 2* order by tablespace_name, file_id10:37:24 SYS@yktdadv > /TABLESPACE_NAME FILE_NAME-------------------- ----------------------------------------------------------------------ADV_M01_TBS /data/oraadv/oraadv_data/adv/adv_m01_tbs001.dbfADV_M01_TBS /data/oraadv/oraadv_data/adv/adv_m01_tbs002.dbfADV_M01_TBS /data/oraadv/oraadv_data/adv/adv_m01_tbs003.dbfADV_M01_TBS /data/oraadv/oraadv_data/adv/adv_m01_tbs004.dbfADV_M02_TBS /data/oraadv/oraadv_data/adv/adv_m02_tbs001.dbfADV_M02_TBS /data/oraadv/oraadv_data/adv/adv_m02_tbs002.dbfADV_M02_TBS /data/oraadv/oraadv_data/adv/adv_m02_tbs003.dbfADV_M02_TBS /data/oraadv/oraadv_data/adv/adv_m02_tbs004.dbfADV_M03_TBS /data/oraadv/oraadv_data/adv/adv_m03_tbs001.dbfADV_M03_TBS /data/oraadv/oraadv_data/adv/adv_m03_tbs002.dbfADV_M03_TBS /data/oraadv/oraadv_data/adv/adv_m03_tbs003.dbfADV_M03_TBS /data/oraadv/oraadv_data/adv/adv_m03_tbs004.dbfADV_M04_TBS /data/oraadv/oraadv_data/adv/adv_m04_tbs001.dbfADV_M04_TBS /data/oraadv/oraadv_data/adv/adv_m04_tbs002.dbfADV_M04_TBS /data/oraadv/oraadv_data/adv/adv_m04_tbs003.dbfADV_M04_TBS /data/oraadv/oraadv_data/adv/adv_m04_tbs004.dbfADV_M05_TBS /data/oraadv/oraadv_data/adv/adv_m05_tbs001.dbfADV_M05_TBS /data/oraadv/oraadv_data/adv/adv_m05_tbs002.dbfADV_M05_TBS /data/oraadv/oraadv_data/adv/adv_m05_tbs003.dbfADV_M05_TBS /data/oraadv/oraadv_data/adv/adv_m05_tbs004.dbfADV_M06_TBS /data/oraadv/oraadv_data/adv/adv_m06_tbs001.dbfADV_M06_TBS /data/oraadv/oraadv_data/adv/adv_m06_tbs002.dbfADV_M06_TBS /data/oraadv/oraadv_data/adv/adv_m06_tbs003.dbfADV_M06_TBS /data/oraadv/oraadv_data/adv/adv_m06_tbs004.dbfADV_M07_TBS /data/oraadv/oraadv_data/adv/adv_m07_tbs001.dbfADV_M07_TBS /data/oraadv/oraadv_data/adv/adv_m07_tbs002.dbfADV_M07_TBS /data/oraadv/oraadv_data/adv/adv_m07_tbs003.dbfADV_M07_TBS /data/oraadv/oraadv_data/adv/adv_m07_tbs004.dbfADV_M08_TBS /data/oraadv/oraadv_data/adv/adv_m08_tbs001.dbfADV_M08_TBS /data/oraadv/oraadv_data/adv/adv_m08_tbs002.dbfADV_M08_TBS /data/oraadv/oraadv_data/adv/adv_m08_tbs003.dbfADV_M08_TBS /data/oraadv/oraadv_data/adv/adv_m08_tbs004.dbfADV_M09_TBS /data/oraadv/oraadv_data/adv/adv_m09_tbs001.dbfADV_M09_TBS /data/oraadv/oraadv_data/adv/adv_m09_tbs002.dbfADV_M09_TBS /data/oraadv/oraadv_data/adv/adv_m09_tbs003.dbfADV_M09_TBS /data/oraadv/oraadv_data/adv/adv_m09_tbs004.dbfADV_M10_TBS /data/oraadv/oraadv_data/adv/adv_m10_tbs001.dbfADV_M10_TBS /data/oraadv/oraadv_data/adv/adv_m10_tbs002.dbfADV_M10_TBS /data/oraadv/oraadv_data/adv/adv_m10_tbs003.dbfADV_M10_TBS /data/oraadv/oraadv_data/adv/adv_m10_tbs004.dbfADV_M10_TBS /data/oraadv/oraadv_data/adv/adv_m10_tbs005.dbfADV_M11_TBS /data/oraadv/oraadv_data/adv/adv_m11_tbs001.dbfADV_M11_TBS /data/oraadv/oraadv_data/adv/adv_m11_tbs002.dbfADV_M11_TBS /data/oraadv/oraadv_data/adv/adv_m11_tbs003.dbfADV_M11_TBS /data/oraadv/oraadv_data/adv/adv_m11_tbs004.dbfADV_M12_TBS /data/oraadv/oraadv_data/adv/adv_m12_tbs001.dbfADV_M12_TBS /data/oraadv/oraadv_data/adv/adv_m12_tbs002.dbfADV_M12_TBS /data/oraadv/oraadv_data/adv/adv_m12_tbs003.dbfADV_M12_TBS /data/oraadv/oraadv_data/adv/adv_m12_tbs004.dbfADV_TBS /data/oraadv/oraadv_data/adv/adv_tbs001.dbfADV_TBS /data/oraadv/oraadv_data/adv/adv_tbs002.dbfADV_TBS /data/oraadv/oraadv_data/adv/adv_tbs003.dbfADV_TBS /data/oraadv/oraadv_data/adv/adv_tbs004.dbfADV_TBS /data/oraadv/oraadv_data/adv/adv_tbs005.dbfDEV1_BIPLATFORM /data/oraadv/oraadv_data/yktdadv/DEV1_biplatform.dbfDEV1_MDS /data/oraadv/oraadv_data/yktdadv/DEV1_mds.dbfDEV_BIPLATFORM /data/oraadv/oraadv_data/yktdadv/dev_biplatform001.dbfDEV_MDS /data/oraadv/oraadv_data/yktdadv/dev_mds01.dbfDIM_TBS /data/oraadv/oraadv_data/dim/dim_tbs001.dbfDIM_TBS /data/oraadv/oraadv_data/dim/dim_tbs002.dbfDIM_TBS /data/oraadv/oraadv_data/dim/dim_tbs003.dbfIND_BIEE_TBS /data/oraadv/oraadv_data/adv/ind_biee_tbs001.dbfLOG_TBS /data/oraadv/oraadv_data/log/log_tbs001.dbfODS_TBS /data/oraadv/oraadv_data/ods/ods_tbs001.dbfSYSAUX /data/oraadv/oraadv_data/yktdadv/sysaux01.dbfSYSTEM /data/oraadv/oraadv_data/yktdadv/system01.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_01.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_21.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_22.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_23.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_24.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_25.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_02.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_03.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_04.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_05.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_06.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_07.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_08.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_09.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_10.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_11.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_12.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_13.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_14.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_15.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_16.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_17.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_18.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_19.dbfUNDOTBS1 /data/oraadv/oraadv_data/yktdadv/undotbs1_20.dbfUSERS /data/oraadv/oraadv_data/yktdadv/users01.dbfXMLDB_TS /data/oraadv/oraadv_data/yktdadv/xmldb_ts.dbf93 rows selected. oracle中创建触发器错误, oracle root不能以system用户登录 如何在游标for循环中排除不想要的记录 如何将本地的EXCEL导入到已经建好的表中呢? Oracle不能创建触发器? 初学者提问 谁能给个oracle9i 在windows2000 pro 下的安装手册? date数据怎么表示 听说oracle 10g出来了,哪里有下载啊? Reuse是什么意思? 没用过Oracle求帮助,将sql改为Oracle oracle 怎么导入SqlServer数据
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.