Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > oracle > answers

Data Import

Newbie
  
Join Date: Feb 2008
Posts: 2
#1: Feb 28 '08
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's Avatar
Moderator
  
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,504
#2: Feb 28 '08

re: Data Import

You can't directly import dump file of SQL Server into Oracle.
Newbie
  
Join Date: Feb 2008
Posts: 2
#3: Feb 29 '08

re: Data Import

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.
Reply

« previous question | next question »

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,295 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved