Online Documentation for SQL Manager for Oracle

Directories

A Directory database object specifies an alias for a directory on the server file system where external binary file LOBs (BFILEs) and external table data are located. You can use directory names when referring to BFILEs in your PL/SQL code and OCI calls, rather than hard coding the operating system path name, for management flexibility.

Directory Editor allows you to define directory properties. It opens automatically when you create a new directory and is available on editing an existing one.

To open a directory in Directory Editor, double-click it in the DB Explorer tree.

• Using Navigation bar and Toolbar
• Creating/editing directory
• Viewing DDL definition