GGSCI (aproccbrac500.nwc.com.sa) 5> view params EXPUMPA
EXTRACT EXPUMPA
USERID tttt, password uuuuu
RMTHOST 10.48.18.66, MGRPORT 7909
RMTTRAIL G:\ogg12.3\dirdat\ha
--- NOPASSTHRU
table gg_admin.test1;
table cisadm.CI_ACCT, cols (ACCT_ID,SETUP_DT,CIS_DIVISION) ;
--- table cisadm.CI_ACCT, cols (ACCT_ID,SETUP_DT,CIS_DIVISION) , where (CIS_DIVISION = 'TCBU');
---table CISADM.HAYAT_ONLINE_STG;
----table CISADM.HAYAT_ONLINE_STG, cols (SUBS_NO,BILL_NO,TOT_VAL_REQ,CIS_DIVISION,BATCH_NBR,CREATE_TIME,OUTMSGSTATUSFLG) ;
GGSCI (aproccbrac500.nwc.com.sa) 6> view params EXTPG
EXTRACT EXTPG
SETENV (ORACLE_HOME = '/oraccb/app/oracle/product/12.1.0.2/dbhome_1')
SETENV (TNS_ADMIN = '/oraccb/app/oracle/product/12.1.0.2/dbhome_1/network/admin')
userid tttt, password uuuuu
TRANLOGOPTIONS DBLOGREADER
EXTTRAIL /oragg/app/product/12.3/dirdat/cg
nocompressupdates
NOCOMPRESSDELETES
--- GETUPDATEBEFORES
table hyt_ogg.test;
table cisadm.HAYAT_ONLINE_STG;
table cisadm.ci_acct , where (cis_division = 'TCBU');
--- table cisadm.CI_ACCT ;
--- table cisadm.CI_ACCT , where (CIS_DIVISION = 'TCBU');
GGSCI (APROSQLDBS220) 12> view params REPHYTAC
REPLICAT rephytac
--- DBOPTIONS USEODBC
targetdb ogg2, USERID yyy, PASSWORD xxxx
DISCARDFILE G:\ogg12.3\dirrpt\rephytac.DSC, PURGE
ALLOWNOOPUPDATES
--- APPLYNOOPUPDATES
--- MAP CISADM.HAYAT_ONLINE_STG, TARGET DBO.RD_CCB_bills, COLMAP (ACCT_ID=SUBS_NO, CCBBILL_ID=BILL_NO, DUE_AMOUNT = @NUMSTR (TOT_VAL_REQ), CIS_DIVISION=CIS_DIVISION, BATCH_NO=BATCH_NBR, CRE_DT=CREATE
TIME, IS_PROCESSED= @COLSTAT (NULL)), where (CIS_DIVISION = 'TCBU') ,keycols(ACCT_ID);
MAP CISADM.CI_ACCT, TARGET DBO.NWC_MIGRATED_CUSTOMERS, COLMAP (ACCT_ID=ACCT_ID,CREATED_TIME=SETUP_DT,CREATED_BY=CIS_DIVISION) ;
--- MAP gg_admin.test1,dbo.test1