Oracle Tips by Burleson
Chapter 6 Oracle Tablespace and File
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.
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:
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'
The Oracle script collection contains more than 600 working Oracle scripts. You can download them immediately at this link: