Hi all,
I have an exported dump (by exp tool) from Oracle 10 XE where database charset is WE8MSWIN1252.
No I've installed Oracle 11 XE where charset is automatically AL32UTF8.
When I run imp tool I got errros for some rows like a title shows. Some rows were rejected but later I have problem with reference constrains "ORA-02298 cannot validate -parent keys not found"
I understand that probably column's width were defined as byte length instead of char, and some values are now longer.
What I'm sure that I cannot extend columns on source database and export again. I just dispose of dump file.
Is possible to import data by way that some values will by automatically cut. They are mostly some descriptions and so on?
I read something on web and try following two tries:
1.Added additional initializaton parameter:
black_trimminng=true
2.Import first metadata and later rows:
-import metadata with flag ROWS=N
-import again everything with IGNORE=Y
-here I got another problem like table is mutating...trigger/function may not see it
Can somebody help me?