Dts

I am trying to copy a table from Access into Oracle using DTS. I let DTS to create the table in Oracle and then populate it with data. It creates the table but as soon as it tries to copy the data I get an error message: Table does not exist. Any idea why?I am trying to copy a table from Access into Oracle using DTS. I let DTS to create the table in Oracle and then populate it with data. It creates the table but as soon as it tries to copy the data I get an error message: Table does not exist. Any idea why?

More of an Oracle question really than SQL. I'm not the expert on Oracle, but I would gues that it has to do with schema ownership. Try qualifying the name of the table in the DTS package with the owner (usually the user id underwhich the table was created).

Regards,

hmscott