ORA-39001: invalid argument value – Rodrigo Silva e Silva

Erro ao realizar import Erro

[oracle@dbora bkp_logico]$ time impdp system/"senha"@OLTP  dumpfile='/u02/bkp_logico/OLTP.DMP' logfile=IMP_OLTP_27022020.log schemas=PROD,TESTE

Import: Release 19.0.0.0.0 - Production on Thu Feb 27 19:12:04 2020
Version 19.5.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39088: file name cannot contain a path specification

[oracle@dbora bkp_logico]$ time impdp system/"senha"@OLTP dumpfile='/u02/bkp_logico/OLTP.DMP' logfile=IMP_OLTP_27022020.log schemas=PROD,TESTE

Import: Release 19.0.0.0.0 - Production on Thu Feb 27 19:12:04 2020

Version 19.5.0.0.0

Connected to: Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-39088: file name cannot contain a path specification

Causa Usuário sys sem permissão Solução

SYSTEM@OLTP > grant read, write on DIRECTORY DIRECTORY to sys;

Grant succeeded.

SYSTEM@OLTP > grant read, write on DIRECTORY DIRECTORY to sys;

Grant succeeded.

Resolvido!

Tag: ORA-39001: invalid argument value

Expdp Oracle 11G ORA-39001: invalid argument value, ORA-01775: looping chain of synonyms

Impdp erro ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-39088: file name cannot contain a path specification