export data into oracle by odbc connection porblem

hi 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

aamirmaster

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|||Make sure that you use a valid user, Scott/tiger is in Oracle just a sample user which should be deactivated for security reasons. Create a new user assign him the appropiate permissions in oracle and use this user to export data to the Oracle system. Make sure that you don′t hit a quota during the import of the data.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
--sql