I am facing issues when trying to import data from an Oracle 19c SE (on Windows Server 2016) to an Oracle 18c XE (on Oracle Linux 8.10) using Oracle Data Pump.
Problem Details:
Export: I use the following expdp command to generate the dump file in Oracle 19c:
expdp system/password@BDPROD directory=dp_prod dumpfile=backup.dmp logfile=backup.log full=y version=18.0
Importing Metadata: I use the following impdp command to create the structure in Oracle 18c XE:
impdp system/password@pdb directory=dp_dir dumpfile=backup.dmp logfile=impbackup.log sqlfile=ddl.sql
The structure is created successfully.
I try to import only the data with the following impdp command:
impdp system/password@pdb schemas=esquema1 directory=dp_dir dumpfile=backup.dmp logfile=impbackup.log remap_tablespace=USERS:TBS content=DATA_ONLY
Errors Observed: When executing the import command, I encounter the following error:
ORA-39002: invalid operation
Troubleshooting Attempts:
- Verified that the timezones between the source and destination databases are consistent (
+00:00).
- Generated and reviewed the dump file contents using the
sqlfile parameter to ensure it contains the expected structure and data.
- Verified that the
system user permissions and roles are correct (IMP_FULL_DATABASE and DBA).
Requesting Assistance For:
- Diagnosing the cause of the
ORA-39002 error when importing data with impdp.
- Ensuring that the parameters and configurations used in
expdp and impdp are correct for this migration scenario.
- Any additional recommendations to successfully complete the data import from Oracle 19c Standard Edition to Oracle 18c Express Edition.
Thank you for your help.