Managing data files location.
--- 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.
==========