Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 BCP ORA

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2005-03-25 : 07:04:18
Can i use BCP to import data into oracle?

------------------------
I think, therefore I am

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-03-25 : 07:08:52
No.
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2005-03-25 : 07:11:28
OK.
Can i use BCP to import data into SQL2K from oracle?

------------------------
I think, therefore I am
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-03-25 : 07:12:30
If it was exported from Oracle to a text file, yes. bcp only works with text files or SQL Server native format data files.
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2005-03-25 : 07:16:04
Got it. Thanks.

------------------------
I think, therefore I am
Go to Top of Page
   

- Advertisement -