| importing an 8i dump file into a 9i db [message #70281] |
Sat, 18 May 2002 17:37  |
atlmok
Messages: 2
Registered: May 2002
|
Junior Member |
|
|
Hi folks,
I am having trouble importing an 8.1.5 dump file into a 9.0.1 database ... I'm doing a fromuser - touser import.
The 8.1.5 is on RH6.2 using a US7ASCII character set. The 9.0.1 is on RH7.2 using a WE8ISO8859P1 character set.
My log files show that the import works for some tables but fails for others. This is what my log files show:
Connected to: Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
Export file created by EXPORT:V08.01.05 via direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export server uses US7ASCII NCHAR character set (possible ncharset conversion)
.
.
.
IMP-00008: unrecognized statement in the export file:
^B^P)4^G
IMP-00008: unrecognized statement in the export file:
^Z^Mþáþáþáþáþá^E
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
.
.
.
. . importing table "PRODUCT_CATEGORY"
...........................................................................
................................... 1905517 rows imported
.
.
Some tables get created but some don't and many parts of the log file show IMP-00008.
I'm not sure if it is a character set problem ... but since US7ASCII is a subset of WE8ISO8859P1, I didn't think it would be a problem.
Oracle docs say that the 9i import utility is backwards compatible so I didn't think that using an 8i dump file would cause a problem too.
So I'm really running out of ideas ... please help =)
atlmok
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
