Importar

Bash
impdp SYSTEM@CURTITS DIRECTORY=datapump DUMPFILE=qualitat_orig.dmp SCHEMAS=QUALITAT

Exportar

Bash
expdp SYSTEM@BD DIRECTORY=data_pump_dir DUMPFILE=qualitat.dmp LOGFILE=qualitat.log SCHEMAS=QUALITAT

Crear directori

SQL
CREATE OR REPLACE DIRECTORY "DATA_PUMP_DIR" as '/app/oracle/product/11.2.0/dbhome_1/rdbms/log/';

Consultar directoris

SQL
SELECT owner, directory_name, directory_path FROM dba_directories WHERE directory_name='DATA_PUMP_DIR';

Per copiar-ho via ssh quan el servidor té protocols i algoritmes vells:

PowerShell
scp -o HostKeyAlgorithms=+ssh-rsa -o PubkeyAcceptedAlgorithms=+ssh-rsa root@curtits.fym.local:/usr/oracle/app/admin/BD/dpdump/*20241030.dmp .
Visites: 4.354