If you have a non-system user account and you want to export all data objects in the schema associated with your account, you can use the "expdp" command with the SCHEMAS parameter. Running "expdp" command with a non-system user account requires a directory object granted to this user account. The following tutorial exercise shows you how to define a directory object and export a schema:

>mkdir oraclexehr_dump

>cd oraclexeapporacleproduct10.2.0serverBIN

>sqlplus /nolog

SQL> connect SYSTEM/globalguideline

SQL> CREATE DIRECTORY hr_dump AS 'oraclexehr_dump';

Directory created.

SQL> GRANT READ ON DIRECTORY hr_dump TO hr;

Grant succeeded.

SQL> GRANT WRITE ON DIRECTORY hr_dump TO hr;

Grant succeeded.

SQL> quit

>expdp hr/globalguideline SCHEMAS=hr

DIRECTORY=hr_dump DUMPFILE=schema.dmp LOGFILE=schema.log