SQL Maestro Group / Products / Oracle / Oracle Maestro / Documentation

Oracle Maestro online help

A directory 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.

All directories are created in a single namespace and are not owned by an individual schema. You can secure access to the BFILEs stored within the directory structure by granting object privileges on the directories to specific users.

New directories are created within Create Directory Wizard. In order to run the wizard you should either

•	select the Object \| Create Database Object... main menu item;

•	select the Directory icon in the Create Database Object dialog

•	select the Directory list or any object from that list in the explorer tree;

•	select the Create New Directory... item from the popup menu

•	open the schema in Schema Editor and the Directory tab there;

•	press the Insert key or select the Create New Directory item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

To create a new directory with the same properties as one of the existing directory has:

•	select the Object \| Duplicate Database Object... main menu item;

•	follow the instructions of Duplicate Object Wizard.

Directories can be edited within Directory Editor. In order to run the editor you should either

•	select the directory for editing in the explorer tree (type the first letters of the

directory name for quick search);

•	select the Edit Directory... item from the popup menu

•	open the schema in Schema Editor and the Directory tab there;

•	select the directory to edit;

•	press the Enter key or select the Edit Directory item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

To drop a directory:

•	select the directory to drop in the explorer tree;

•	select the Drop Directory item from the popup menu

•	open the schema in Schema Editor and the Directory tab there;

•	select the directory to drop;

•	press the Delete key or select the Drop Directory item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

and confirm dropping in the dialog window.