Oct 24, 2022

Oracle datapumping

expdp user@SID SCHEMAS=schema1,schema2 DIRECTORY=dir DUMPFILE=file.dmp
impdp user@SID SCHEMAS=schema1,schema2 DIRECTORY=dir DUMPFILE=file.dmp

The directory in the DIRECTORY param is not what you naively think, is an oracle directory object that you can define on the database with:

CREATE DIRECTORY dir AS '/my/dir';