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