import failed [message #73844] |
Thu, 22 July 2004 23:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
uhud
Messages: 1 Registered: July 2004
|
Junior Member |
|
|
hi, i imported a .dmp file but i got this error:
Connected to: Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production
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
Then i run the catexp.sql using SYS user. But i still got that error. Any Suggestions?
|
|
|
|
|
|
Re: import failed [message #484604 is a reply to message #484599] |
Wed, 01 December 2010 23:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/1aa06ade0c173e60e8cf2af78518db5d?s=64&d=mm&r=g) |
sharminjose
Messages: 8 Registered: December 2010 Location: US
|
Junior Member |
|
|
Hi Bhadresh,
I went through the website and it says that,
Export_From-----Import_To-----Export_Version_to_Use-----Import_Version_to_Use
Release 10.2-----Release 11.2 Data Pump-----Export Release 10.2 Data Pump-----Import Release 11.2
In my case, the Import_To is 10.2 and Export_From is 10.2. But the Import_Version_to_Use is 11.2.
If you look at my imp log, it says clearly that the export was done in 10.2 and import is done using 11.2.
Please see below:
Import: Release 11.2.0.1.0 - Production on Wed Dec 1 16:33:03 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V10.02.01 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing WFDEV's objects into WFDEV
. . skipping TOID validation on type MDSYS.SDO_ORDINATE_ARRAY
. . skipping TOID validation on type MDSYS.SDO_ELEM_INFO_ARRAY
. . skipping TOID validation on type MDSYS.SDO_GEOMETRY
. . importing table "FRAME_DO_STYLES"
IMP-00058: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00058: ORACLE error 942 encountered
ORA-00942: table or view does not exist 1218 rows imported
Import terminated successfully with warnings.
The funniest part is that the import completes successfully.
The command used is below:
imp userid=test_user/test_pass@wfdev file=frame_do_styles.dmp fromuser=WF_USER touser=test_user TOID_NOVALIDATE=MDSYS.SDO_ORDINATE_ARRAY,MDSYS.SDO_ELEM_INFO_ARRAY,MDSYS.SDO_GEOMETRY ignore=y
Any thoughts?
Thanks,
Sharmin
[Updated on: Wed, 01 December 2010 23:46] Report message to a moderator
|
|
|
Re: import failed [message #484728 is a reply to message #484595] |
Thu, 02 December 2010 08:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
sharminjose wrote on Wed, 01 December 2010 17:43Hi Mahesh,
I exported the dmp file in a 10g client and 'am getting the below error when I try to import it from a 11g client to a 10g dB.
Use a 10g client to import into a 10g database.
|
|
|
|
|
|
Re: import failed [message #484752 is a reply to message #484750] |
Thu, 02 December 2010 09:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:So is there any ways, I can import a dmp file from 11g client to 10g server?
This question is not clear.
You cannot import a 11g export file into a 10g database (unless you are very lucky).
Regards
Michel
[Updated on: Thu, 02 December 2010 09:50] Report message to a moderator
|
|
|
|
|
Re: import failed [message #484760 is a reply to message #484756] |
Thu, 02 December 2010 12:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/1aa06ade0c173e60e8cf2af78518db5d?s=64&d=mm&r=g) |
sharminjose
Messages: 8 Registered: December 2010 Location: US
|
Junior Member |
|
|
Guys,
I guess if I use expdp it might work with the target server's version.
It is mentioned here (Add http and www before "dbforums.com/oracle/1643901-importing-dump-file-oracle-11g-oracle-10g.html").
Anyways, thanks for the helps.
Thanks,
Sharmin
[Updated on: Thu, 02 December 2010 12:09] Report message to a moderator
|
|
|
Re: import failed [message #484765 is a reply to message #484751] |
Thu, 02 December 2010 13:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
BlackSwan wrote on Thu, 02 December 2010 10:40You repeatedly talk about V10 & V11 HOWEVER
>Connected to: Oracle8i Release 8.1.6.0.0 - Production
>JServer Release 8.1.6.0.0 - Production
original post deals with obsoleted & unsupported V8.1.6
Please clarify.
Actually, that was from a different person 6 years ago. New poster jumped onto this thread as it was a similar problem.
|
|
|
Re: import failed [message #484767 is a reply to message #484760] |
Thu, 02 December 2010 13:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
sharminjose wrote on Thu, 02 December 2010 13:09Guys,
I guess if I use expdp it might work with the target server's version.
It is mentioned here (Add http and www before "dbforums.com/oracle/1643901-importing-dump-file-oracle-11g-oracle-10g.html").
You are not really giving good details. And export file created by exp command cannot be used by impdp. It can only be used by imp.
Do you already have the export file and cannot create a new one?
Why not export with 11g client and then import with 11g client. you might get lucky there.
|
|
|
Re: import failed [message #484796 is a reply to message #484767] |
Thu, 02 December 2010 15:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/1aa06ade0c173e60e8cf2af78518db5d?s=64&d=mm&r=g) |
sharminjose
Messages: 8 Registered: December 2010 Location: US
|
Junior Member |
|
|
Hi Joy,
I am not really sure what extra details you need.
I said above that,
"In my case, the Import_To is 10.2 and Export_From is 10.2. But the Import_Version_to_Use is 11.2."
I have a 10g export file and needs to be imported from 11g client to 10g server.
Also, I know that the exp file is different from expdp file.
What I plan to do is, imp the 10g export file to 10g and expdp it to a new dmp file with target VERSION 10g.
Again, the import works from a 11g client to 10g server with a 10g export dmp.
But it gives out, table does not exist error even the table exists and with ignore=y option
My assumption is, with this expdp file, it would work if then do an import data pump with any higher clients.
I have still not completed it. If this gets successful, will let you know.
Why not export with 11g client and then import with 11g client. you might get lucky there.
In my case, I can have 10g clients as well as 11g clients, but server will be always 10g.
Thanks,
Sharmin
[Updated on: Thu, 02 December 2010 15:34] Report message to a moderator
|
|
|
Re: import failed [message #484803 is a reply to message #484796] |
Thu, 02 December 2010 19:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
sharminjose wrote on Thu, 02 December 2010 21:32
I have a 10g export file and needs to be imported from 11g client to 10g server.
So is that an export from a 10g database? Or is it taken with 10g export? Or both?
There are 4 relevant versions here:
Source DB
Target DB
Import
Export
Plus you should get in the habit of stating the full version - 4 decimals.
sharminjose wrote on Thu, 02 December 2010 21:32
Also, I know that the exp file is different from expdp file.
What I plan to do is, imp the 10g export file to 10g and expdp it to a new dmp file with target VERSION 10g.
And what's that going to accomplish apart from making things more compilcated?
sharminjose wrote on Thu, 02 December 2010 21:32
Again, the import works from a 11g client to 10g server with a 10g export dmp.
But it gives out, table does not exist error even the table exists and with ignore=y option
So why not use the 10g import? That would be the actual correct way of doing it as previously stated.
sharminjose wrote on Thu, 02 December 2010 21:32
In my case, I can have 10g clients as well as 11g clients, but server will be always 10g.
What's the point of having 11g clients if the DB is always going to be 10g?
|
|
|
|
|
|
Re: import failed [message #484845 is a reply to message #484843] |
Fri, 03 December 2010 02:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:I was looking for a better option and wished to see if you could help me.
Install a 10g client on all machines.
Regards
Michel
|
|
|