[oracle@oracle backup]$ sqlplus "/as sysdba";
SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 10 18:49:16 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select file_id,file_name from dba_data_files;
FILE_ID
----------
FILE_NAME
--------------------------------------------------------------------------------
4
/opt/oracle/oradata/portaldb/users01.dbf
3
/opt/oracle/oradata/portaldb/undotbs01.dbf
2
/opt/oracle/oradata/portaldb/sysaux01.dbf
FILE_ID
----------
FILE_NAME
--------------------------------------------------------------------------------
1
/opt/oracle/oradata/portaldb/system01.dbf
5
/oradata/portaldb_ICMLFQ32_01.dbf
6
/oradata/portaldb_ICMLNF32_01.dbf
FILE_ID
----------
FILE_NAME
--------------------------------------------------------------------------------
7
/oradata/portaldb_ICMSFQ04_01.dbf
8
/oradata/portaldb_ICMVFQ04_01.dbf
9
/oradata/portaldb_ICMLSNDX_01.dbf
9 rows selected.
阅读(923) | 评论(0) | 转发(0) |
