Results 1 to 2 of 2

Thread: Dts

  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: 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?

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by inka
    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
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •