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 73

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle regular expression 6 47
Clone Oracle 12c Database 5 43
Migrate Oracle Database from ASM to Non-ASM on a Windows server. 1 33
database upgrade 8 41
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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 explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

896 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now