I am attempting to copy a table from SQL Server 2000 to
Oracle 9.2 via DTS ODBC. But it keeps generating error
that Oracle user does not exist. ODBC test connection
works fine. I just applied SP 3, but that did not help.

And what user is it trying to create as the table owner ? If "dbo" then
AFAIK Oracle doesn't have one unless you have added him/her

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Frank Kluytmans" <frank (AT) petrodat (DOT) com> wrote