Home » RDBMS Server » Server Utilities » character set erro while importing. (ORACLE 10.2.0.1.0)
character set erro while importing. [message #511078] Thu, 09 June 2011 09:39 Go to next message
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
Re: character set erro while importing. [message #511079 is a reply to message #511078] Thu, 09 June 2011 09:41 Go to previous messageGo to next message
BlackSwan
Messages: 22536
Registered: January 2009
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!
Re: character set erro while importing. [message #511080 is a reply to message #511078] Thu, 09 June 2011 09:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
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.
Re: character set erro while importing. [message #511081 is a reply to message #511079] Thu, 09 June 2011 09:46 Go to previous messageGo to next message
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
Re: character set erro while importing. [message #511082 is a reply to message #511081] Thu, 09 June 2011 09:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Please help me out Sir.
How exactly and what seems to be the problem?
Re: character set erro while importing. [message #511083 is a reply to message #511081] Thu, 09 June 2011 09:49 Go to previous messageGo to next message
cookiemonster
Messages: 10853
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?

Re: character set erro while importing. [message #511084 is a reply to message #511081] Thu, 09 June 2011 09:49 Go to previous messageGo to next message
BlackSwan
Messages: 22536
Registered: January 2009
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!
Re: character set erro while importing. [message #511107 is a reply to message #511083] Thu, 09 June 2011 11:25 Go to previous messageGo to next message
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
Re: character set erro while importing. [message #511109 is a reply to message #511107] Thu, 09 June 2011 11:28 Go to previous messageGo to next message
BlackSwan
Messages: 22536
Registered: January 2009
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
Re: character set erro while importing. [message #511110 is a reply to message #511107] Thu, 09 June 2011 11:28 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
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
Re: character set erro while importing. [message #511111 is a reply to message #511084] Thu, 09 June 2011 11:28 Go to previous messageGo to next message
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
Re: character set erro while importing. [message #511112 is a reply to message #511111] Thu, 09 June 2011 11:29 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
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 Go to previous messageGo to next message
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
Re: character set erro while importing. [message #511115 is a reply to message #511114] Thu, 09 June 2011 11:36 Go to previous messageGo to next message
cookiemonster
Messages: 10853
Registered: September 2008
Location: Rainy Manchester
Senior Member
Is it actually causing you a problem?
Re: character set erro while importing. [message #511118 is a reply to message #511115] Thu, 09 June 2011 11:44 Go to previous message
BlackSwan
Messages: 22536
Registered: January 2009
Senior Member
>but what about the problem of character set.
PROBLEM? What Problem?
I don't see any problem.
Problem have error code & message.
Previous Topic: Tables moved using export and import
Next Topic: backup_problem_with_repliction_project
Goto Forum:
  


Current Time: Wed Jul 30 15:29:31 CDT 2014

Total time taken to generate the page: 0.12614 seconds