Tuesday, 2 August 2016

How to view datafile and control file in oracle 11g?

To view datafile location:-


SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/XE/system.dbf
/u01/app/oracle/oradata/XE/sysaux.dbf
/u01/app/oracle/oradata/XE/undotbs1.dbf
/u01/app/oracle/oradata/XE/users.dbf
/u01/app/oracle/oradata/XE/arul.dbf


To view Control file location?

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/XE/control.dbf





No comments:

Post a Comment