Data Import

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • akshaykoul01
    New Member
    • Feb 2008
    • 2

    Data Import

    Hi,
    I have to import some data from sql server to my oracle 10g.
    I have exported the data from sql server into one dump file and now if i use
    the command imp username=scott/tiger@test owner='(domain1 ,domain1)' file=abc.dmp but there is some error like character set error .
    if i directly try to import data from dump file it is not working also :(
    Any help ??
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    You can't directly import dump file of SQL Server into Oracle.

    Comment

    • akshaykoul01
      New Member
      • Feb 2008
      • 2

      #3
      Hi,
      Thanks for the information.
      do you know the procedure to import data from dump file of sql server into oracle ?? if yes, kindly let me know.

      Comment

      Working...