Re: export / import problem

On Fri, 25 Feb 2005 05:53:50 GMT, Kalle <kminerva_at_jippii.fi> wrote:

>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
>

And to add another possibility: was your target table empty before the import?

Jaap. Received on Sat Feb 26 2005 - 04:48:39 CST