ExpDP

select * from dba_directories;

CREATE OR REPLACE DIRECTORY

DATA_PUMP_DIR AS

'/u02/oracle/backup';

CREATE OR REPLACE DIRECTORY

DMPDIR AS

'/u02/oracle/backup';

CREATE OR REPLACE DIRECTORY

TEMP_DIR AS

'/u02/oracle/TEMP';

impdp \"/ as sysdba\" DIRECTORY=datapump DUMPFILE=pf-2011-09-26.dmp FULL=y logfile=impdp_pf.log

impdp \"/ as sysdba\" DIRECTORY=TEMP_DIR DUMPFILE=pf-2011-09-26.dmp SCHEMAS=system logfile=impdp_pf.log

exp spacewalk/Chexxx owner=spacewalk consistent=y statistics=none file=spacewalk.oracleXE.dmp log=spacewalk.oracleXE.log

imp \'/ as sysdba\' fromuser=spacewalk touser=spacewalk file=spacewalk.oracleXE.dmp log=spacewalk.oracleXE.imp.log ignore=y

@?/rdbms/admin/utlrp.sql

exec dbms_stats.gather_schema_stats('SPACEWALK');