Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Qian Dong: "Although I evaluated Oracle Maestro for only a couple of days, I must say I like what I saw in this product. I am going to place an order for this product.

Thank you for the good work".
Bernhard Hartl: "Oracle Maestro works great - thank you for that really good product and the very good User Interface".

More

Add your opinion

Oracle Maestro online help

Prev Return to chapter overview Next

Directories

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

or

select the Directory list or any object from that list in the explorer tree;
select the Create New Directory... item from the popup menu

or

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

or

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

or

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.

 



Prev Return to chapter overview Next