Re: Import Dump in Linux

On Sun, 14 May 2006 08:44:37 +0900, "takesiro" <takesiro_at_coral.ocn.ne.jp> wrote:

>Hi!
>First of all, two databases are different charactor set( Unix-EUC,
>Windows-W1532 ?)
>That connot import data, because of charactor set.
>But you are probably import to your database with automatic charactor
>transrations.
>So you will confirm to database, what user tablespace use XXX charactor set.
>
>When you add option FROMUSER and TOUSER, ORACLE database check
>FROMUSER and TOUSER charactor set.(please add those option, if same
>username)
>It will be transration EUC to W1532.

Your response is, sorry to say so, completely incorrect. Charactersets are being defined on *database* level, not on *tablespace* level!!!
Characterset conversion during import is being determined by the NLS_LANG environment variable of the import session, and has *NOTHING AT ALL* to do with the FROMUSER and TOUSER parameter.

Could you please verify your answers, to avoid completely *MISLEADING* potential victims?

--
Sybrand Bakker, Senior Oracle DBA