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

       

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks