OraFAQ Forum: Server Utilities » character set erro while importing.

Home » RDBMS Server » Server Utilities » character set erro while importing. (ORACLE 10.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

character set erro while importing. [message #511078]

Thu, 09 June 2011 09:39

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Hi All,

I have oracle 10.2.0.4.0 installed on Window server 2008 [Machine A] and oracle 10.2.0.1.0 on windowx xp [Machine b].
Now I have taken the export of database on windows server 2k8 [Machine a] by puting the entry in the tnsname.ora file of Windox XP [Machine b].

Now when I am importing on the same machine I am getting the below mentioned error:

C:\Documents and Settings\dsharma>IMP FROMUSER=SYSTEM TOUSER=ESCDBO FILE='D:\share\vcc53_0106.dmp' LOG='D:\share\vcc53_0106_IMP.LOG' ignore=y

Import: Release 10.2.0.1.0 - Production on Thu Jun 9 20:08:11 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: system
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in WE8MSWIN1252 character set and UTF8 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export client uses US7ASCII character set (possible charset conversion)
Import terminated successfully without warnings.

Thanks
Deepak

Report message to a moderator

Re: character set erro while importing. [message #511079 is a reply to message #511078]

Thu, 09 June 2011 09:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Now when I am importing on the same machine I am getting the below mentioned error:
NO Error!
>Import terminated successfully without warnings.
read & heed above!

Report message to a moderator

Re: character set erro while importing. [message #511080 is a reply to message #511078]

Thu, 09 June 2011 09:46

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

AS BlackSwan said,
there is no visible error in the post.
And it seems you are having custom objects in System schema.
Not advisable.

Report message to a moderator

Re: character set erro while importing. [message #511081 is a reply to message #511079]

Thu, 09 June 2011 09:46

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

I understand but there are no tables are imported in the database.

By same machine I mean that from where I have taken export. ie. Export of database on windows server 2008 from oracle 10.2.0.1.0 on windows xp.

Please help me out Sir.

Thanks
Deepak

Report message to a moderator

Re: character set erro while importing. [message #511082 is a reply to message #511081]

Thu, 09 June 2011 09:49

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Please help me out Sir.
How exactly and what seems to be the problem?

Report message to a moderator

Re: character set erro while importing. [message #511083 is a reply to message #511081]

Thu, 09 June 2011 09:49

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

dsharma wrote on Thu, 09 June 2011 15:46

I understand but there are no tables are imported in the database.

Are tables supposed to be imported?

Report message to a moderator

Re: character set erro while importing. [message #511084 is a reply to message #511081]

Thu, 09 June 2011 09:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

as a general rule no objects owned by SYS or SYSTEM are ever exported since import requires a functioning DB that already has SYS & SYSTEM users.
This is the price you pay for using Oracle schemas, SYS & SYSTEM, when explicitly direct to never do so!

Report message to a moderator

Re: character set erro while importing. [message #511107 is a reply to message #511083]

Thu, 09 June 2011 11:25

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

I have check the export file and all the tables of the escdbo user were listed there...

Thanks
Deepak

Report message to a moderator

Re: character set erro while importing. [message #511109 is a reply to message #511107]

Thu, 09 June 2011 11:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I have check the export file and all the tables of the escdbo user were listed there...
SO?
imp was not directed to use ESCDBO tables; only SYSTEM tables!
FROMUSER=SYSTEM

Report message to a moderator

Re: character set erro while importing. [message #511110 is a reply to message #511107]

Thu, 09 June 2011 11:28

Michel Cadot
Messages: 68454
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Maybe but you asked to import SYSTEM objects (see your FROMUSER clause).

Regards
Michel

Report message to a moderator

Re: character set erro while importing. [message #511111 is a reply to message #511084]

Thu, 09 June 2011 11:28

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Hi Blackswan,

I have used the command for export

exp system/oracle file='/path/to/file/' log='/path/to/file' owners=escdbo

Now I dont think I am exporting the objects of sys and system here. Please clear my mistake if had done Sir.

Thanks
Deepak

Report message to a moderator

Re: character set erro while importing. [message #511112 is a reply to message #511111]

Thu, 09 June 2011 11:29

Michel Cadot
Messages: 68454
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Please clear my mistake if had done Sir.

Maybe you should read the documentation about a tool before using it.
What is the meaning of FROMUSER option?

Oracle did EXACTLY what you asled it to do.

Regards
Michel

[Updated on: Thu, 09 June 2011 11:30]

Report message to a moderator

Re: character set erro while importing. [message #511114 is a reply to message #511112]

Thu, 09 June 2011 11:34

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Ok thanks for the reply Michel Sir. Got my mistake.
Thanks to everyone.

but what about the problem of character set. how to elliminate that.

Regards
Deepak

Report message to a moderator

Re: character set erro while importing. [message #511115 is a reply to message #511114]

Thu, 09 June 2011 11:36

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

Is it actually causing you a problem?

Report message to a moderator

Re: character set erro while importing. [message #511118 is a reply to message #511115]

Thu, 09 June 2011 11:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>but what about the problem of character set.
PROBLEM? What Problem?
I don't see any problem.
Problem have error code & message.

Report message to a moderator

Previous Topic:	Tables moved using export and import
Next Topic:	backup_problem_with_repliction_project

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 04 18:19:30 CDT 2023