Golden Gate replication for workspace manager objects
From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Thu, 15 Dec 2016 06:06:57 -0800
Message-ID: <CAHDOOG4mZWe-OGe_+UjuHroZLKKxVjXbUA3kqsRmpXLFmCtsjg_at_mail.gmail.com>
Hello:
This is the structure of the object. We want to replicate to target database.
Name of the object : xxra.sp_projects > This is a view which is created like this
"select
"PROJECT_ID","ENTITY_ID","PROJECT_STATUS_ID","SHORT_PROJECT_NAME","FULL_PROJECT_NAME","PROJECT_IDENTIFIER","PROJECT_AGREEMENT_TYPE_ID","OWNING_ORG_UNIT_ID","EFFECTIVE_DATE","TRANSACTION_ID","CNV_PROJECT_KEY","CNV_ROW_VERSION","CNV_CREATE_DATE","CNV_RETIRE_DATE","CNV_TRANSACTION_KEY","CNV_SPO_TITLE","PI_PERSON_ID","CNV_AGREEMENT_TYPE","CNV_CONTRACT_TYPE","CNV_READ_ONLY_FLAG","PROJECT_KEYWORDS","TEST_FLAG"
from wmsys.wm$61$$"
Date: Thu, 15 Dec 2016 06:06:57 -0800
Message-ID: <CAHDOOG4mZWe-OGe_+UjuHroZLKKxVjXbUA3kqsRmpXLFmCtsjg_at_mail.gmail.com>
Hello:
This is the structure of the object. We want to replicate to target database.
Name of the object : xxra.sp_projects > This is a view which is created like this
"select
"PROJECT_ID","ENTITY_ID","PROJECT_STATUS_ID","SHORT_PROJECT_NAME","FULL_PROJECT_NAME","PROJECT_IDENTIFIER","PROJECT_AGREEMENT_TYPE_ID","OWNING_ORG_UNIT_ID","EFFECTIVE_DATE","TRANSACTION_ID","CNV_PROJECT_KEY","CNV_ROW_VERSION","CNV_CREATE_DATE","CNV_RETIRE_DATE","CNV_TRANSACTION_KEY","CNV_SPO_TITLE","PI_PERSON_ID","CNV_AGREEMENT_TYPE","CNV_CONTRACT_TYPE","CNV_READ_ONLY_FLAG","PROJECT_KEYWORDS","TEST_FLAG"
from wmsys.wm$61$$"
wmsys.wm$61$$ is another view that is dependent on wmsys.wm$61$_base$.
It looks like it is not possible to setup extract and replicat for workspace manager objects. Just want to clarify that.
Thanks for your time.
Kumar
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 15 2016 - 15:06:57 CET