Description
The CREATE DIRECTORY command creates an alias for a file system pathname.
The directory alias is defined by using the CREATE DIRECTORY command. The
CREATE DIRECTORY command takes two parameters. The first is the directory name
and the second parameter is the internal alias for the full path directory where
the actual files reside. The dir_name is used to act as a pointer or locator for
the actual files. All the new files created by utl_file package are created in
this virtual directory which is given as a argument to utl_file functions.
See for details.
Examples
For a WINDOWS system:
CREATE DATABASE lusiadas;
To create a database sales owned by user salesapp
with a default tablespace of salesspace:
CREATE DIRECTORY dir1 AS 'C:/temp';
For a LINUX system:
CREATE OR REPLACE DIRECTORY gif_dir AS '/usr/local/graphics/gif';
