Oracle_SQL_Scripts/dba_directories.sql at master · bibucket/Oracle_SQL_Scripts

22 lines (18 loc) · 663 Bytes

-- | PURPOSE : Provides a summary report of all Oracle Directory objects. |

-- | NOTE : As with any code, ensure to test this script in a development |

-- | environment before attempting to run it in production. |

-- +----------------------------------------------------------------------------+

SET PAGESIZE 9999

SET VERIFY OFF

COLUMN owner FORMAT a10 HEADING 'Owner'

COLUMN directory_name FORMAT a30 HEADING 'Directory Name'

COLUMN directory_path FORMAT a85 HEADING 'Directory Path'

SELECT

owner

, directory_name

, directory_path

FROM

dba_directories

ORDER BY

owner

, directory_name;

Provide feedback