Re: Import/Export Problem

On 7 Oct 2004 09:09:13 -0700, iamrakeshp_at_yahoo.com wrote:

>hi All,
> i am having problem importing the database .The export is
>done as system and I am importing as system.
>The export is done with direct=Y . I cant even import one table from
>the export file. The file is rcopied from one machine to another so no
>ftp problems there .
>Changed the NLS_LANG parameter too but nothing works .
>

Without digging too deeply, I strongly suggest that you export with direct=n and retry the import.

Direct mode export is faster, but it does not do NLS conversion between the exp and imp database (applies to 9i and downwards, haven't checked with 10g).

Never use direct=y. The export is faster, but not the import, and it takes usually a lot longer than the export. The benefit of direct=y is thus marginal, and the drawback you may have already experienced.

• Kenneth Koenraadt