--1. Source DB
expdp system/<password>@<orcl> DIRECTORY=db_backup DUMPFILE=FALABELLA_SO_20080808.DMP SCHEMAS=<CATA>,<CATB>,<CORE>,<PUB> logfile=expdp_falabella_SO_20080808.log parallel=1 CONTENT=ALL COMPRESSION=ALL FLASHBACK_TIME=sysdate
--2. Target DB
alter user <CATA> account lock;
alter user <CATB> account lock;
alter user <CORE> account lock;
alter user <PUB> account lock;
SELECT 'ALTER SYSTEM KILL SESSION '''||SID||','||SERIAL#||''';' AS SQL FROM V$SESSION WHERE USERNAME IN ('<CATA>','<CATB>','<CORE>','<PUB>');
CREATE directory DB_BACKUP as '/opt/oracle/db_backup';
GRANT read,write ON directory DB_BACKUP TO public;drop