export / import problem

From: Kalle <kminerva_at_jippii.fi>
Date: Fri, 25 Feb 2005 05:53:50 GMT
Message-ID: <O3zTd.300$v4.6054@news2.nokia.com>

Hi all,

I have a strange problem:

We have a production and development environments on different servers. I need to do every now and then copies from prod to another environment, this is done with exp/imp.

Those servers are both behind a firewall so I need to copy a dump using an ftp....

Environments are on HP-UX and both have same oracle version (9.2.0.4) and of course same character settings, both export and import will be done with UTF8 characterset. But reason or another there will happen some problems during import. I cannot validate or create unique indexes because of similar rows...

How is this possible because there are no multiple rows on source database...

Where does the character conversion happen or what is happening here? I am confused, well, this is not the first time, but still :)

Any ideas where to find the reason or solution...

Kalle Received on Thu Feb 24 2005 - 23:53:50 CST