Solved

create directories in oracle

Posted on 2011-03-20
2
256 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 74

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html 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…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
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.

739 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