Post reply

Replication from MSSQL to Oracle

  • October 1, 2008 at 8:45 am

    #193769

    I am trying to replicate a large DBase into an Oracle warehouse.

    I have successfully tested with a couple of tables on the test server.

    However, Now when I am trying to replicate to the live server, I get the error message

    " ORA-00942: table or view does not exist "

    The replication table has been created, but none of the database tables from the subscription are created.

  • October 3, 2008 at 4:05 am

    #880365

    I have done some more work on this. As Oracle seems to be more stringent with naming convention, you may have to edit publication scripts to change table names, and be very careful how you name your columns.

    If you are interested, I have posted some useful stuff on the MS forum.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply