July 7, 2003 at 4:26 am
Hi All
I am trying to export data from an SQL Server database to an Oracle database on the same PC. I am using the DTS wizard. Everything seems it is going to work fine until at the last stage I got a series of errors: [ORACLE][ODBC][ORA]00942:table or view does not exist and [ORACLE][ODBC][ORA]001918 user 'xxxx' does not exist. What can I be doing wrong? What should I be doing?
July 7, 2003 at 5:59 am
Have you tried using the Microsoft OLEDB Provider for Oracle or the Microsoft ODBC Driver for Oracle instead of the Oracle driver?
Joseph
July 8, 2003 at 6:37 am
Are you prefixing your Oracle target table with the correct owner name? Sounds like DTS thinks 'xxxx' is the Oracle owner/schema target.
July 8, 2003 at 6:43 am
I am now using the Microsoft OLEDB Provider for Oracle as fromnaija ) suggested and it is working just fine. It is taking it's time though. Has been running for about 18 hours. Millions of rows of data is being copied over though.
July 8, 2003 at 9:34 am
Next time you may want to just BCP the data out and use Oracle's version of BCP (I forget what it is called) to bring the data in. Don't know if ODBC is adding any value in your case.
July 8, 2003 at 3:04 pm
Oracle's version of BPC is Sqlloader
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply