OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » import

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

import [message #224711]

Thu, 15 March 2007 04:02

oracle_coorgi
Messages: 188
Registered: September 2006
Location: INDIA-karnataka

Senior Member

hi
i getting the error when importing
export client uses US7ASCII character set (possible charset conversion)
export was done in direct path and version 10.01.0.0
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import done in version 10.1.02.0
thanxs

Report message to a moderator

Re: import [message #224713 is a reply to message #224711]

Thu, 15 March 2007 04:07

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
export client uses US7ASCII character set (possible charset conversion)
export was done in direct path and version 10.01.0.0
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import done in version 10.1.02.0

what is error ?

above is not error it is show message which database character set are using during import / export time.

regards
Taj

Report message to a moderator

Re: import [message #224731 is a reply to message #224713]

Thu, 15 March 2007 04:43

oracle_coorgi
Messages: 188
Registered: September 2006
Location: INDIA-karnataka

Senior Member

this was due to the wrong fromuser=
ok
one more thing is that when i had issued the imp command
c:\imp syste......@xxx file=data142007.dmp fromuser=bill touser=blore
it said this was exported by bsabkp not by u
when i tried with bsabkp it did not import
when called to concerned people they give me different user
fromuser=newbill which was correct

my question now is that why did i get error saying bsabkp user

thanxs

Report message to a moderator

Re: import [message #224876 is a reply to message #224731]

Thu, 15 March 2007 16:38

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Oracle just informed you that "export was done by bsabkp, not by you". This shouldn't worry you as it is NOT an error message, just an information.

Of course, if you want this import to succeed, FROMUSER must exist in a .DMP file, as well as TOUSER must exist in a target database.

Report message to a moderator

Previous Topic:	Exporting schema of complete database for all the users
Next Topic:	export tables only without data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 20:34:52 CST 2024