 |
|
ss
Oracle Tips by Burleson |
Chapter 6 Oracle Tablespace and File
Internals Scripts
SELECT
owner,
directory_name,
directory_path
FROM
dba_directories
ORDER BY
owner;
SPOOL OFF
SET VERIFY ON FEEDBACK ON
TTITLE OFF
CLEAR COLUMNS
A sample of the output is shown below.
Remember, directories aren’t verified for existence until access is
attempted.
Owner
Directory Full Path
----------
--------------- ----------------------------------------
SYS
MEDIA_DIR /project/linux/install/d2/pse/cus/901/demo/sc
hema/product_media/
SYS
LOG_FILE_DIR /project/linux/install/d2/pse/cus/901/admin/s
tp1/create/
SYS
DATA_FILE_DIR /project/linux/install/d2/pse/cus/901/demo/sc
hema/sales_history/
SYS
SQL_DIR /home/oracle/sql_scripts
Monitoring Libraries
The Oracle script collection contains more than 600 working Oracle scripts. You can download them immediately at this link:
|
