create directories in oracle

Posted on 2011-03-20
Last Modified: 2012-05-11

    -- ============================================
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.
Question by:nobleit

Expert Comment

ID: 35176980
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.
LVL 74

Accepted Solution

sdstuber earned 500 total points
ID: 35177032
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle SQL 6 73
migration MS SQL database to Oracle 30 69
Email query results in HTML 6 31
Checking for column width 8 29
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question