 |
|
ss
Oracle Tips by Burleson |
Chapter 6 Oracle Tablespace and File
Internals Scripts
Directory and Library Internals
Oracle8 introduced two new internal database
structures, directories and libraries. Libraries point to external
sharable libraries of 3GL routines. They can be called via the
external procedures call option, also new to Oracle8. Directories
point to external directories, where BFILE and other LOB data
objects can be stored outside the database.
Monitoring Directories
Directory information is available from the
dba_directories view. This view has three columns. A simple report
will show everything the database knows about directories:
dir_rep.sql
COLUMN owner FORMAT a10 HEADING 'Owner'
COLUMN directory_name FORMAT a15 HEADING 'Directory'
COLUMN directory_path FORMAT a45 HEADING 'Full Path'
SET VERIFY OFF PAGES 58 LINES 78 FEEDBACK OFF
ttitle 'Database Directories Report'
SPOOL dir_rep.lis
The Oracle script collection contains more than 600 working Oracle scripts. You can download them immediately at this link:
|