Hi all,
in a dev environment we have a server with an Oracle Client Version 21.9.
From this machine we can start a shell batch that connect to a database Oracle 19.6 with a wallet and executes expdp of a schema and then it imports the dump into another schema, these are the commands that executes:
expdp /@UNIV_ORA DIRECTORY=BCK_DIR \
SCHEMAS=THEUSER1 \
EXCLUDE=USER,GRANT,STATISTICS,PROCEDURE,TABLE:"IN \( \'PPEBATCHEXECUTION\' \)" \
DUMPFILE=THEUSER1_export.dmp \
LOGFILE=THEUSER1_export.log \
COMPRESSION=ALL
impdp /@UNIV_ORA DIRECTORY=BCK_DIR \
EXCLUDE=USER,GRANT,STATISTICS,PROCEDURE \
REMAP_SCHEMA=THEUSER1:THEUSER2 \
REMAP_TABLESPACE=DAT_THEUSER1:DAT_THEUSER2 \
REMAP_TABLESPACE=IDX_THEUSER1:IDX_THEUSER2 \
TABLE_EXISTS_ACTION=REPLACE \
DUMPFILE=THEUSER1_export.dmp \
LOGFILE=THEUSER2_import.log
About the wallet, UNIV_ORA is the alias of a user named UNIV_ORA.
Now I'm trying to migrate to a new server with Oracle 19.30 installed.
To prepare the new database I exported from the source THEUSER1 and UNIV_ORA and import them on the new oracle server. I created, obviously, all tablespaces and THEUSER2 too (it is empty). The two oracle instances had about the same parameters. UNIV_ORA has these roles:
CONNECT, DATAPUMP_EXP_FULL_DATABASE, DATAPUMP_IMP_FULL_DATABASE, RESOURCE.
When we start the batch, it exported correctly the dump but exit the import with error:
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
UDI-06550: operation generated ORACLE error 6550
ORA-06550: riga 1, colonna 72:
PL/SQL: ORA-00942: tabella o vista inesistente
ORA-06550: riga 1, colonna 42:
PL/SQL: SQL Statement ignored
On server side, the alert log shows this:
2026-02-16 10:31:19.240000 +01:00
DM00 started with pid=181, OS id=653467, job UNIV_ORA.SYS_IMPORT_FULL_01
2026-02-16 10:31:24.216000 +01:00
DM00 stopped with pid=181, OS id=653467, job UNIV_ORA.SYS_IMPORT_FULL_01
and the import log file is not written on disk.
I checked the directory path, directory grant for user UNIV_ORA and it's all ok.
I also tried to import the dump file with UNIV_ORA without using the wallet from oracle server and the import works, if I try from the client machine it does not work.
Any idea?
Thanks