Solved

create directories in oracle

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

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.
0
Comment
Question by:nobleit
2 Comments
 
LVL 7

Expert Comment

by:MrNed
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.
0
 
LVL 73

Accepted Solution

by:
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
0

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