Re: Multiple SID's (instances) possible with Oracle 8 (Unix)?

gschnei_at_genre.com wrote:
> Hi Frank,
>
> what do you mean with "loading double byte cs into single byte
> instance"? Is WE8ISO8859P1 singlebyte? If so, then I think that the
> JDBC-driver from Oracle is doing the job of conversion.
>
> I've now doenloaded the OracleMigrationWorkbench and try to migrate our
> MySQLData directly, see if that's an option.
>
> Btw., the error-message I got when using SQLLoader to load UTF-8 into
> the KO16KCS5601 instance was ORA-02353 MultibyteCharacter error, but
> this message and Google didn't help much either.
>
> Anyways, keep your fingers crosses that OMWB's working...
>
> Cheers!
>
> Greg
>

OMWB will produce flat files, which are to be loaded with SQL*Loader. Same mechanism, you currently use.

It took me just a few seconds to find this in the Error Mesaages and Codes manual:

ORA-02353: multi-byte character error
Cause: The text specified by POSITION or terminated by new lines is invalid. Action: Edit the control file or the datafile to fix the alignment of the column.

And yes, WE8xxxxxx charactersets are West European, 8 bits (that's where the acronym stands for). Possibly you have NCHAR fields (or any other datatype in the National Language set)?

Final question: does the import job at the Korean side set nls_lang to we8iso8859p1? Worth a try, I'd say.

Else, post some data, the SQL*Loader control file, and the table definition.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...