| ORA-22337 when imp dmp file with user defined type [message #72865] |
Mon, 24 November 2003 04:47  |
terence
Messages: 5
Registered: September 2002
|
Junior Member |
|
|
Hi,
I got error when I use oracle imp utility to import a dmp file that has user define type. The error are:
Import: Release 9.2.0.1.0 - Production on Mon Nov 24 19:38:01 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by G2FO, not by you
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
import server uses ZHT16BIG5 character set (possible charset conversion)
export client uses ZHT16BIG5 character set (possible charset conversion)
export server uses UTF8 NCHAR character set (possible ncharset conversion)
. . importing table "ORDER_QTY_DTL"
IMP-00058: ORACLE error 22337 encountered
ORA-22337: the type of accessed object has been evolved
About to enable constraints...
IMP-00086: TOID "HKEX_TYP" not found in export file
Import terminated successfully with warnings.
I couldn't search error ORA-22337. Anybody know that?
Much Thanks!
Terence
|
|
|
|
| Re: ORA-22337 when imp dmp file with user defined type [message #73376 is a reply to message #72865] |
Tue, 06 April 2004 00:38  |
Katherine Golubowski
Messages: 1
Registered: April 2004
|
Junior Member |
|
|
Dear Terrence,
I know this is a rather late answer but maybe by now you can help me.
I encountered the same error.
You must have altered the object of the object table
ORDER_QTY_DTL.
This causes this error.
In oracle one finds following error message:
ORA-22337 the type of accessed object has been evolved
Cause: The type of the accessed object has been altered and the client's object is based on an earlier type definition.
Action: The user needs to exit the application and modify the application to accommodate the type change. From SQL/PLUS, reconnect and resubmit the statement.
Do you by now know how to import the data
|
|
|
|
| Re: ORA-22337 when imp dmp file with user defined type [message #73378 is a reply to message #73376] |
Tue, 06 April 2004 02:24 |
terence
Messages: 5
Registered: September 2002
|
Junior Member |
|
|
Hi Golubowski,
I tried the suggestion from other replies. But it still didn't work. I really don't have the exact answer on this issue.
Eventually, I build another new DB to solve my problem. That is the export data can't import into my existing DB, but can import into a newly build DB.
Terence
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
