Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

issue doing import from 19c to 18c

Tony007May 27 2021

hi am having this issue
impdp username/password@dbname schemas=username directory=images dumpfile=username.dmp logfile=impdpnato.log version=18.0.0

Import: Release 18.0.0.0.0 - Production on Thu May 27 16:43:31 2021
Version 18.3.0.0.0

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

Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39358: Export dump file version 19.0.0.0.0 not compatible with target version 18.1.0.0.0

bash-4.1$ impdp username/password@dbname schemas=username directory=images dumpfile=username.dmp logfile=impdpnato.log version=18.1.0

Import: Release 18.0.0.0.0 - Production on Thu May 27 16:44:49 2021
Version 18.3.0.0.0

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

Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39358: Export dump file version 19.0.0.0.0 not compatible with target version 18.1.0

bash-4.1$ impdp username/password@dbname schemas=username directory=images dumpfile=username.dmp logfile=impdpnato.log version=19.0.0

Import: Release 18.0.0.0.0 - Production on Thu May 27 16:46:09 2021
Version 18.3.0.0.0

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

Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
ORA-39002: invalid operation

bash-4.1$

Comments
Post Details
Added on May 27 2021
8 comments
4,525 views