How to create directory in oracle database

            How to create directory in oracle database

Syntax:-

Using the 'create directory' statement to create a directory object in an Oracle database. The following statement creates a directory database object that points to a directory on the server:
CREATE OR REPLACE DIRECTORY <directory_name> AS '<UNIXBOX_system_path>';

Note:- 'directory_name’ is unique directory name and ‘UNIXBOX_system_path' specify the full path name of operating system directory of the server.


SQL> CREATE OR REPLACE DIRECTORY testing AS '/u01/TESTING';

SQL> GRANT READ, WRITE ON DIRECTORY testing TO APPS;


To check the Directory created.

SQL>SELECT * FROM DBA_DIRECTORIES;

SQL> SELECT * FROM ALL_DIRECTORIES;

OS Commend to create a directory:-

#mkdir -p /u01/TESTING
#chmod -R 777 /u01/TESTING

#ls -ltr /u01/TESTING