Managing data files location.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Sat, 04 Mar 2017 19:54:58 +0200
changeset 2111 f780f1b08e12
parent 2110 1cf4c735fa6d
child 2112 86ec943e6823
Managing data files location.
oracle.rst
--- a/oracle.rst	Fri Mar 03 00:24:11 2017 +0200
+++ b/oracle.rst	Sat Mar 04 19:54:58 2017 +0200
@@ -106,6 +106,29 @@
   select * from USER_TAB_PRIVS
   select * from USER_ROLE_PRIVS
 
+Managing data files location
+============================
+
+To find out where is data files located run as ``sysdba``::
+
+  select * from dba_data_files;
+  select * from dba_temp_files;
+
+Above files represent table spaces::
+
+  select * from dba_tablespaces;
+
+Another information about installation::
+
+  select * from v$controlfile;
+  select * from v$tablespace;
+  select * from v$database;
+  show parameter control_files;
+
+Place for dumps::
+
+  show parameter user_dump_dest;
+
 Profiling.
 ==========