Connect

sqlplus / as sysdba

sqlplus

CREATE OR REPLACE DIRECTORY test_dir AS '/u01/app/oracle/oradata/';
GRANT READ, WRITE ON DIRECTORY test_dir TO scott;
SELECT DIRECTORY_NAME, DIRECTORY_PATH FROM ALL_DIRECTORIES

export

expdp scott/tiger full=Y SCHEMA=scott directory=TEST_DIR dumpfile=DB10G.dmp logfile=expdpDB10G.log

import

impdp scott_new/<password> remap_schema=scott:scott_new remap_tablespace=scott_tbs:scott_tbs_new directory=test_dir dumpfile=DB10G.dmp logfile=impdpDB10G.log schemas=scott content=all

tout simplement : drop SYS_IMPORT_SCHEMA_0