Create directory access for export data pump
Getting Started
- Prepare directories for users who want to use the export data pump
[oracle@labdbT1 trace]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/ol-root 27G 18G 9.0G 67% / devtmpfs 3.8G 0 3.8G 0% /dev tmpfs 3.9G 1.9G 2.0G 48% /dev/shm tmpfs 3.9G 13M 3.9G 1% /run tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup /dev/sda1 1014M 362M 653M 36% /boot tmpfs 782M 36K 782M 1% /run/user/202 /dev/sr0 52G 52G 0 100% /run/media/oracle/29_01_2012 tmpfs 782M 0 782M 0% /run/user/0 [oracle@labdbT1 db]$ [oracle@labdbT1 db]$ [oracle@labdbT1 db]$ [oracle@labdbT1 db]$ cd $ORACLE_BASE [oracle@labdbT1 ~]$ [oracle@labdbT1 ~]$ ls -lthr total 4.0K drwxrwxr-x. 3 oracle oinstall 20 Feb 4 02:20 product drwxrwxr-x. 3 oracle oinstall 4.0K Feb 4 02:24 SW drwxr-xr-x. 2 oracle oinstall 6 Feb 4 03:25 checkpoints drwxr-x---. 3 oracle oinstall 18 Feb 4 03:26 oradiag_oracle drwxr-x---. 4 oracle oinstall 30 Feb 4 03:27 cfgtoollogs drwxr-x---. 3 oracle oinstall 19 Feb 4 03:34 admin drwxr-x---. 3 oracle oinstall 19 Feb 4 03:34 flash_recovery_area drwxr-x---. 3 oracle oinstall 19 Feb 4 03:34 oradata drwxrwxr-x. 3 oracle oinstall 19 Feb 4 03:34 diag drwxr-xr-x. 2 oracle oinstall 31 Feb 15 11:28 arch [oracle@labdbT1 ~]$ [oracle@labdbT1 ~]$ [oracle@labdbT1 ~]$ [oracle@labdbT1 ~]$ pwd /home/oracle [oracle@labdbT1 ~]$ [oracle@labdbT1 ~]$ [oracle@labdbT1 ~]$ [oracle@labdbT1 ~]$ mkdir exp_dir [oracle@labdbT1 ~]$ [oracle@labdbT1 ~]$ ls -lthr total 4.0K drwxrwxr-x. 3 oracle oinstall 20 Feb 4 02:20 product drwxrwxr-x. 3 oracle oinstall 4.0K Feb 4 02:24 SW drwxr-xr-x. 2 oracle oinstall 6 Feb 4 03:25 checkpoints drwxr-x---. 3 oracle oinstall 18 Feb 4 03:26 oradiag_oracle drwxr-x---. 4 oracle oinstall 30 Feb 4 03:27 cfgtoollogs drwxr-x---. 3 oracle oinstall 19 Feb 4 03:34 admin drwxr-x---. 3 oracle oinstall 19 Feb 4 03:34 flash_recovery_area drwxr-x---. 3 oracle oinstall 19 Feb 4 03:34 oradata drwxrwxr-x. 3 oracle oinstall 19 Feb 4 03:34 diag drwxr-xr-x. 2 oracle oinstall 31 Feb 15 11:28 arch drwxr-xr-x. 2 oracle oinstall 6 Feb 22 22:01 exp_dir [oracle@labdbT1 ~]$ [oracle@labdbT1 ~]$ [oracle@labdbT1 ~]$ [oracle@labdbT1 ~]$ [oracle@labdbT1 ~]$ sqlplus "/as sysdba" SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 22 22:18:32 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> SQL> SQL> desc dba_directories Name Null? Type ----------------------------------------- -------- ---------------------------- OWNER NOT NULL VARCHAR2(30) DIRECTORY_NAME NOT NULL VARCHAR2(30) DIRECTORY_PATH VARCHAR2(4000) SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> set line 900 SQL> set pagesi 900 SQL> col DIRECTORY_PATH for a400 SQL> col OWNER for a10 SQL> col DIRECTORY_PATH for a100 SQL> select * from dba_directories OWNER DIRECTORY_NAME DIRECTORY_PATH ---------- ------------------------------ ---------------------------------------------------------------------- SYS ORACLE_OCM_CONFIG_DIR /home/oracle/product/11.2.0/db/ccr/state SYS DATA_PUMP_DIR /home/oracle/admin/DB11G/dpdump/ SYS MEDIA_DIR /home/oracle/product/11.2.0/db/demo/schema/product_media/ SYS XMLDIR /ade/b/2125410156/oracle/rdbms/xml SYS DATA_FILE_DIR /home/oracle/product/11.2.0/db/demo/schema/sales_history/ SYS LOG_FILE_DIR /home/oracle/product/11.2.0/db/demo/schema/log/ SYS SS_OE_XMLDIR /home/oracle/product/11.2.0/db/demo/schema/order_entry/ SYS SUBDIR /home/oracle/product/11.2.0/db/demo/schema/order_entry//2002/Sep 8 rows selected. SQL> create directory EXP_DIR as '/home/oracle/exp_dir'; Directory created. SQL> select * from dba_directories; OWNER DIRECTORY_NAME DIRECTORY_PATH ---------- ------------------------------ ---------------------------------------------------------------------- SYS ORACLE_OCM_CONFIG_DIR /home/oracle/product/11.2.0/db/ccr/state SYS DATA_PUMP_DIR /home/oracle/admin/DB11G/dpdump/ SYS MEDIA_DIR /home/oracle/product/11.2.0/db/demo/schema/product_media/ SYS XMLDIR /ade/b/2125410156/oracle/rdbms/xml SYS DATA_FILE_DIR /home/oracle/product/11.2.0/db/demo/schema/sales_history/ SYS LOG_FILE_DIR /home/oracle/product/11.2.0/db/demo/schema/log/ SYS SS_OE_XMLDIR /home/oracle/product/11.2.0/db/demo/schema/order_entry/ SYS SUBDIR /home/oracle/product/11.2.0/db/demo/schema/order_entry//2002/Sep SYS EXP_DIR /home/oracle/exp_dir 9 rows selected. SQL> SQL> SQL> grant read,write on directory EXP_DIR to suphisara; Grant succeeded. SQL>