Zero Downtime Installation Guide for Oracle

Back Next

Populate the Schemas

The

deploy_zdt

command automatically updates the C_REPOS_ZDT_STATUS repository table in the source and target systems.

The following table summarizes the columns updated in the C_REPOS_ZDT_STATUS repository table:

Column Name	Source Schema Value	Target Schema Value
REPLICATION TARGET IND	0	1
LOCAL ENVIRONMENT NAME	ENVA	ENVB
LOCAL SCHEMA NAME	cmx_ors_a	cmx_ors_b
LOCAL TRAIL PATH	D:/ggs/dirdat/ENVA/	D:/ggs/dirdat/ENVB/
PUMP RMTHOST	[target host name]	[source host name]
PUMP MGRPORT	[target goldengate mgr port, such as 9999]	[source goldengate mgr port, such as 9999]
REMOTE TRAIL PATH	D:/ggs/dirdat/ENVB	D:/ggs/dirdat/ENVA
REMOTE ENVIRONMENT NAME	ENVB	ENVA
REMOTE SCHEMA NAME	cmx_ors_b	cmx_ors_a
REGULAR_STREAM_ID	C	C
EVENT_QUEUE_ID	Q	Q
EXTRACT_PREFIX	E	E
REPLICAT_PREFIX	R	R