Page 1 of 1

export data into oracle by odbc connection porblem

Posted: Sat Jun 17, 2006 6:53 am
by mfa786
master

sir i create odbc connection with oracle

connection test and work right



but when i export data form sqlserver 2000 to oracle with odbc connection and user scott/tigger that time syetem not export data and give me error

Failed to copy 1

Double-click the error row for a detailed description of the error



When click on error then show blow error



[oracle][ODBC][ora]ORA-01918: user ?scott? does not exist



sir please give me idea how i export my data to oracle

thank

aamir