PostgresSQL - Oracle Subscribing problem

Aleksej
2005-05-12
2013-04-22
  • Aleksej
    Aleksej
    2005-05-12

    Hello,
    I've got a problem during Subscriber registration.

    com.daffodilwoods.replication.RepException:
    Error subscribing subscription 'ORA-00903:invalid table name':{1}.

    Information:
    Oracle DB
    Table name public.vat_values
    PostgresSQL  DB
    Table name junda_owner.vat_values

    PostgresSQL works as Publisher and Oracle DB works as Subscriber.

    Does it means two databases must have the same schema names?
    But it is really bad solution.

    Thanks!
    Waiting for your responses,
    Aleksej

     
    • subesingh
      subesingh
      2005-05-13

      Hi,

      It is necessary to have same schema in both data source for publisher and subscriber. Most probably this issue would be sorted out in the next release of replicator.

      Sube Singh