Getting error while importing data to Target oracle environment
Article ID: 233545
Updated On:
Products
Issue/Introduction
Hello Team,
I am currently working on a POC. In this we have copied data for applications one environment to our TDM sandpit environment, Performed some TDM activities and now we have exported data from sandpit server and import it to Target environment of these applications.
While we are running import jobs, our all the jobs getting abended with below mention error message :
Command :
imp %1 ignore=Y rows=Y fromuser=DSL_PREPROD_SERVICES touser=%targetuser% file=AECB_OPERATION_DSL_PREPROD_SERVICES_AECB_OPERATION.dmp
Error :
D:\POC Export Script\DSP_Edited_Final\BESPOKE_OFFER_PRODUCT_OFFER>BESPOKE_OFFER_PRODUCT_OFFER_import.bat [email protected]/DSPPP DSP_PREPROD
Import: Release 18.0.0.0.0 - Production on Mon Jan 17 17:39:41 2022
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V18.00.00 via conventional path
Warning: the objects were exported by QMS_ADMIN, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00023: Import views not installed, please notify your DBA
IMP-00000: Import terminated unsuccessfully
I also used version in my import job but its not working.
imp %1 ignore=Y rows=Y fromuser=DSL_PREPROD_SERVICES touser=%targetuser% file=AECB_OPERATION_DSL_PREPROD_SERVICES_AECB_OPERATION.dmp version=11.2.0.4.0
Can you please help us in resolving this issue.
Environment
Release : 4.9.1
Component :
Resolution
Oralce exp/imp will not allow export from higher version to lower version. Because of this, you are getting an error.
Feedback
