sqlplus /nolog conn sys/pwd as sysdba drop user dtest cascade; create user dtest identified by test; grant connect, resource to dtest; drop directory dpdata1; create directory dpdata1 as '/home/oracle'; grant read, write on directory dpdata1 to dtest; grant EXP_FULL_DATABASE to dtest; grant IMP_FULL_DATABASE to dtest; SELECT directory_path FROM dba_directories WHERE directory_name = 'DPDATA1'; conn dtest/test create table ttest nologging as select object_id, object_name, object_type from all_objects; quit; expdp dtest/test DIRECTORY=dpdata1 DUMPFILE=ttest.dmp