Importar
impdp SYSTEM@CURTITS DIRECTORY=datapump DUMPFILE=qualitat_orig.dmp SCHEMAS=QUALITAT
Exportar
expdp SYSTEM@BD DIRECTORY=data_pump_dir DUMPFILE=qualitat.dmp LOGFILE=qualitat.log SCHEMAS=QUALITAT
Crear directori
CREATE OR REPLACE DIRECTORY "DATA_PUMP_DIR" as '/app/oracle/product/11.2.0/dbhome_1/rdbms/log/';
Consultar directoris
SELECT owner, directory_name, directory_path FROM dba_directories WHERE directory_name='DATA_PUMP_DIR';