Re: Import Dump in Linux

Thank you for your answer.
I understand charactor set is defined by database, and I have a question. I had changed database charactor set before. And I tried import data. I encounterd IMP-00031 error. Is that mean "need FROMUSER and TOUSER".

Thanks for advance.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:28gd621d58uc79inhqghhuu9uedscj0tk5_at_4ax.com...
> 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
Received on Sun May 14 2006 - 01:35:25 CDT