Re: Import Error Code IMP-00069, Please help.

Jian Cheng wrote:

> Hi,
>
> I'm working on my Capstone project within Win2000 and Linux environment. I
> created an Oracle dmp file in User mode using Oracle Export on Win2000 that
> has Oracal 8.1.7 installed. Then I tried to import this dmp file to a Linux
> machine that runs Oracle 8.1.6. Here is the output when I ran Import:
>
>
> ----------------------------------------------------------------------------
> ----------------
> Connected to: Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.0.0 - Production
>
> Export file created by EXPORT:V08.01.07 via conventional path
> import done in US7ASCII character set and US7ASCII NCHAR character set
> IMP-00069: Could not convert to environment national character set's handle
> IMP-00000: Import terminated unsuccessfully
> ----------------------------------------------------------------------------
> ------------------
>
> I would appreciate your help to resolve this problem. Thank you in advance.
>
> Florence
>
>
>
>

The 'law' of export/import says: use the export version of the oldest Oracle version from either source or target system. Thats because the import cant possibly know of future extentions and features, hence it will in case of never export version run into some features only known to later versions. Hence it cant import without terminating unsuccesfully. If you want to import into a 816, use the export that goes with 8.1.6 on your source system.
If both systems are on the same network, start export on the target system as exp user/passwd_at_tns_entry_for_source_system (might have to fix that first).

Rgds
/svend Jensen Received on Tue Apr 30 2002 - 07:21:47 CDT