Home » RDBMS Server » Server Utilities » import
import [message #224711] Thu, 15 March 2007 04:02 Go to next message
oracle_coorgi
Messages: 185
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

Re: import [message #224713 is a reply to message #224711] Thu, 15 March 2007 04:07 Go to previous messageGo to next message
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
Re: import [message #224731 is a reply to message #224713] Thu, 15 March 2007 04:43 Go to previous messageGo to next message
oracle_coorgi
Messages: 185
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

Re: import [message #224876 is a reply to message #224731] Thu, 15 March 2007 16:38 Go to previous message
Littlefoot
Messages: 20901
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.
Previous Topic: Exporting schema of complete database for all the users
Next Topic: export tables only without data
Goto Forum:
  


Current Time: Fri Dec 09 09:42:07 CST 2016

Total time taken to generate the page: 0.08315 seconds