Oracle DataPump 2 – Creating Directory Objects

In order to use Data Pump, the database administrator must create a directory object and grant privileges to the user on that directory object. If a directory object is not specified, a default directory object called data_pump_dir is provided. The default data_pump_dir is available only to privileged users unless access is granted by the DBA.

Login as DBA

To create directory object, first you need to login as DBA (DataBase Adminstrator). Open command prompt (CMD) in windows and type the following

H:\>sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 5 13:30:54 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: CONN / AS SYSDBA
Enter password:

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 – Production

SQL>


Default directory object

data_pump_dir= $ORACLE_BASE/admin/<database_name>/dpdump


Create directory object

SQL> CREATE OR REPLACE DIRECTORY TEST_DIR AS 'D:/A5518/Zzz';

Directory created.

SQL>


View directory object

SELECT * FROM dba_directories;


 

You can leave a response, or trackback from your own site.

Leave a Reply