create directories in oracle


CREATE DIRECTORY OBJECTS FOR O/S DIRECTORIES
    -- ============================================
I have a plan to create directory data on the following path,
I want to make sure that following syntax means the folder data is specified by data,
and actually we are not creating data_dir manually.
    CREATE OR REPLACE DIRECTORY data_dir AS  '/u02/app/external_files/data';
Thank You for your help.
nobleitAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
the Oracle command only creates the "DATA_DIR"  object


you must still go to your operating system and create the /u02/app/external_files/data   filesystem directory
0
 
MrNedCommented:
Not 100% sure what you mean, but running that statement in Oracle will not automatically create the directory for you. You must create it yourself and give access to the oracle user.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.