[oracle@ogg-srv] $>
. ~/.profile.postgres.gg21
$GG/ggsci
start rstock, aftercsn 1408986655
info all
2. Monitoring the replicat operation and waiting for LAG completion
[oracle@ogg-srv] $>
. ~/.profile.postgres.gg21
$GG/ggsci
info rstock
VIEW REPORT rstock
3. Checking the number of rows in tables
-- Postgres
-- Oracle
select 'BONDS',count(*) from STOCK.BONDS union
select 'BONDS_SETTING',count(*) from STOCK.BONDS_SETTING union
select 'BONDS_ZAJVKA',count(*) from STOCK.BONDS_ZAJVKA union
select 'CLIENT_ACCOUNT',count(*) from STOCK.CLIENT_ACCOUNT union
select 'DIVIDENTS',count(*) from STOCK.DIVIDENTS union
select 'JOB_LOGS',count(*) from STOCK.JOB_LOGS union
select 'PORTFOLIO',count(*) from STOCK.PORTFOLIO union
select 'QUOTES',count(*) from STOCK.QUOTES union
select 'QUOTES_ANALYST_15M',count(*) from STOCK.QUOTES_ANALYST_15M union
select 'QUOTES_ANALYST_1H',count(*) from STOCK.QUOTES_ANALYST_1H union
select 'QUOTES_ANALYST_1D',count(*) from STOCK.QUOTES_ANALYST_1D union
select 'QUOTES_VOLUME',count(*) from STOCK.QUOTES_VOLUME union
select 'REPORT_BENEFIT',count(*) from STOCK.REPORT_BENEFIT union
select 'REPORT_BENEFIT_COMPARATOR',count(*) from STOCK.REPORT_BENEFIT_COMPARATOR union
select 'REPORT_EDU',count(*) from STOCK.REPORT_EDU union
select 'REPORT_EDU_COMPARATOR',count(*) from STOCK.REPORT_EDU_COMPARATOR union
select 'SDELKA',count(*) from STOCK.SDELKA union
select 'SIGNAL',count(*) from STOCK.SIGNAL union
select 'TRADING_EDU',count(*) from STOCK.TRADING_EDU union
select 'TRADING_PROD',count(*) from STOCK.TRADING_PROD order by 1;
