Forum Stats

  • 3,854,642 Users
  • 2,264,394 Discussions
  • 7,905,745 Comments

Discussions

Error in REPLICAT

494843
494843 Member Posts: 20
edited Dec 2, 2010 6:36AM in GoldenGate
Using Oracle GoldenGate 11g I get the following error when trying to do a Export/Replicat between two Oracle servers:

2010-11-25 16:35:18 ERROR OGG-01082 The call to the DBOCI_check_for_virtual_column function from get_odbc_table_def failed with return code 0.

This proces is running between two Oracle 11g R2 databases.

Does somebody know what's wrong?

Answers

  • 770151
    770151 Member Posts: 4
    Michael,

    It seems that there are one or more virtual columns in the tables that you are trying to replicate. Virtual columns can be replicated to normal columns only! Use this query to check out if you have any virtual columns:-

    select owner,table_name,column_name,data_type,virtual_column
    from dba_tab_cols
    where owner='xxx' and virtual_column='YES';

    Thanks,

    Satish
  • 494843
    494843 Member Posts: 20
    I did the same thingh with GoldenGate director and now it works correct.
    Don't know what's wrong because the PRM files are identical

    Will look into this further soon..
This discussion has been closed.