Oracle Backup & Recovery Techniques - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 281

C:\>sqlplus / nolog

SQL>CONNECT sys/password@asim AS SYSDBA

OR

C:\>CONNECT sys/password AS SYSDBA
SQL>ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK;

SQL>GRANT CREATE ANY DIRECTORY TO scott;

Step 1: Create directory object
SQL> CREATE DIRECTORY TEST_DATA_PUMP AS
'C:\oradata\datapump';

Step 2: Grant privilege to run the EXPDP
SQL> GRANT EXP_FULL_DATABASE to scott;

Step 3: Grant full permission on directory object to user
SQL>

GRANT READ, WRITE ON DIRECTORY

TEST_DATA_PUMP to scott;

Step 4:

For Database Import/Export:

C:\>expdp SYSTEM/MANAGER@asim FULL=y
DIRECTORY=TEST_DATA_PUMP DUMPFILE=asim_database_full.dmp
LOGFILE=full_expdp.log

C:\>impdp SYSTEM/MANAGER@asim FULL=y
DIRECTORY=TEST_DATA_PUMP DUMPFILE=asim_database_full.dmp
LOGFILE=full_impdp.log