{"id":4123,"date":"2025-06-08T09:06:45","date_gmt":"2025-06-08T09:06:45","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&p=4123"},"modified":"2025-06-08T09:09:45","modified_gmt":"2025-06-08T09:09:45","slug":"create-directory","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/oracle-dba-d2d-tasks\/create-directory\/","title":{"rendered":"Create Directory"},"content":{"rendered":"\n

Directory objects in Oracle map to physical server paths and are required for file operations like expdp<\/code> \/ impdp<\/code>.<\/p>\n\n\n\n

1. Create Physical Directory on Server<\/h3>\n\n\n\n

Run on: DB server as oracle user<\/strong>
Use case: Create a location to store dump\/log files.<\/p>\n\n\n\n

# Create physical path\nmkdir -p \/u01\/dpump_dir\n\n# Set proper ownership and permissions\nchown oracle:oinstall \/u01\/dpump_dir\nchmod 755 \/u01\/dpump_dir<\/code><\/code><\/pre>\n\n\n\n
Note: -p<\/code> = create parent directories automatically if they don’t exist.<\/p>\n\n\n\n
2. Create Directory Object in Database<\/h3>\n\n\n\n
Run in: SQL*Plus as SYSDBA or privileged user<\/strong>
Use case: Map DB object to OS directory for Data Pump.<\/p>\n\n\n\n
-- Create DB directory object\nCREATE DIRECTORY DPUMP_DIR AS '\/u01\/dpump_dir';<\/code><\/code><\/pre>\n\n\n\n
3. Grant Permissions to User<\/h3>\n\n\n\n
Run in: SQL*Plus<\/strong>
Use case: Allow user to access directory during export\/import.<\/p>\n\n\n\n
-- Grant directory access to Data Pump user\nGRANT READ, WRITE ON DIRECTORY DPUMP_DIR TO hr;<\/code><\/code><\/pre>\n\n\n\n
You can also grant to multiple users:<\/p>\n\n\n\n
GRANT READ, WRITE ON DIRECTORY DPUMP_DIR TO SYS, PUBLIC;<\/code><\/code><\/pre>\n\n\n\n
\ud83d\udccc Notes:<\/strong><\/p>\n\n\n\n
    \n
  • Directory names in Oracle are case-insensitive<\/strong>, but by convention, keep them UPPERCASE<\/strong> for clarity.<\/li>\n\n\n\n
  • The directory path<\/strong> must be on the database server<\/strong>, not on the client machine.<\/li>\n\n\n\n
  • Users need two types of permissions<\/strong> to use a directory object successfully:
    \u2022 Database permission<\/strong> to access the directory object
    \u2022 OS-level read\/write permission<\/strong> on the actual filesystem directory<\/li>\n\n\n\n
  • Common naming conventions: use names like DPDIR<\/code>, EXP_DIR<\/code>, or DPUMP_LOGS<\/code> to keep directory objects consistent and recognizable.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
    Directory objects in Oracle map to physical server paths and are required for file operations like expdp \/ impdp. 1. Create Physical Directory on Server Run on: DB server as oracle userUse case: Create a location to store dump\/log files. Note: -p = create parent directories automatically if they don’t exist. 2. Create Directory Object […]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,984],"class_list":["post-4123","cposts","type-cposts","status-publish","hentry","category-notes","category-oracle-dba-d2d-tasks"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/4123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=4123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=4123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}