Directories Wizard (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Wizards

A directory object specifies an alias for a directory on the server file system where external binary file LOBs and external table data are located. The wizard completes a CREATE DIRECTORY statement from the information you supply. The Directory Wizard prompts you to name the directory and provide the full-qualified directory path.

To open the Directories wizard

  1. On the Navigator/Explorer, find the Datasource where you want to create a directory, and then expand the Storage node.
  2. Right-click Directories, and then select New.

The table that follows describes the fields you encountered while completing the wizard.

Required Information Description

What is the name of the directory?

Type a meaningful name for the directory.

What is the directory path?

Type the full path name of the outside operating system directory that you want to alias in the directory (for example, /Video/Library/G_Rated).

Notepad blue icon 2.pngNote: Oracle trusts that the specified directory exists. Be sure to verify that you entered a valid path in the correct format as required by your operating system.

After creating the Directory, you can give other users Read or Write privileges by opening the new Directory on the Directories node, and then making changes on the Privileges tab.