Re: Import and Character sets

Sybrand is right. It's easy to think that because you have your NLS parameters set correctly in your init.ora, that everything is OK.

Van

"Ian" <Mackay_at_novalistech.com> wrote in message news:9eSS5.70387$Z2.936107_at_nnrp1.uunet.ca...
> Hi,
>
> I have an export created from an 8.1.6 db residing on NT.
> I wish to import this database to a 8.1.6. db on solaris.
>
>
> When I try to do so I get the following output:
>
> --start clipping--
> Import: Release 8.1.6.0.0 - Production on Wed Nov 22 11:40:38 2000
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.0.0 - Production
>
> Export file created by EXPORT:V08.01.06 via conventional path
>
> import done in US7ASCII character set and US7ASCII NCHAR character set
> export client uses WE8ISO8859P1 character set (possible charset
 conversion)
> export server uses WE8ISO8859P1 NCHAR character set (possible ncharset
> conversion)
> . importing SCOTT's objects into SCOTT
> . . importing table "XXX_YYY_DATE"
> IMP-00020: long column too large for column buffer size (5)
> --end clipping--
>
>
> I have tried increasing the import buffer size (as suggested in the
 manual)
> to no avail.
>
> I have successfully imported this into an 8.1.6 database running on NT
 woth
> no problems...
> but I NEED it on the UNIX box.
>
> I am certain that it is the character set but I am at a loss for how to
> handle it.
>
> Any help would be greatly appreciated.
>
> Ian.
>
>
>
Received on Thu Nov 23 2000 - 02:09:05 CET