GGSCI (db11) 72> edit params IHREMD1 Extract IHREMD1--------------------------------------------------------------------- Initial Load extract for HR schema-------------------------------------------------------------------SETENV (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)USERID ogg, PASSWORD oggDBOPTIONS ALLOWNOLOGGINGRmtHost 192.168.1.3, mgrport 7809RmtTask Replicat, Group DHREMD1Table HR.T;

GGSCI (db11) 73> ADD EXTRACT IHREMD1, SOURCEISTABLE 

GGSCI (10gasm) 34> edit param dhremd1Replicat DHREMD1--------------------------------------------------------------------- Initial load replicat for HR schema-------------------------------------------------------------------SETENV (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)USERID ogg, PASSWORD oggAssumeTargetDefsMap HR.T, Target HR.T ;~

GGSCI (10gasm) 35> ADD REPLICAT DHREMD1, SPECIALRUN

GGSCI (db11) 74> view report ihremd12014-09-23 23:04:31  INFO    OGG-01017  Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.***********************************************************************                 Oracle GoldenGate Capture for Oracle    Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO   Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:42:16 Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.                    Starting at 2014-09-23 23:04:31***********************************************************************Operating System Version:LinuxVersion #1 SMP Fri Jan 27 17:17:51 EST 2012, Release 2.6.18-308.el5Node: db11Machine: x86_64                         soft limit   hard limitAddress Space Size   :    unlimited    unlimitedHeap Size            :    unlimited    unlimitedFile Size            :    unlimited    unlimitedCPU Time             :    unlimited    unlimitedProcess id: 22239Description: *************************************************************************            Running with the following parameters                  *************************************************************************2014-09-23 23:04:31  INFO    OGG-03035  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.Extract IHREMD1--------------------------------------------------------------------- Initial Load extract for HR schema-------------------------------------------------------------------SETENV (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)Set environment variable (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)USERID ogg, PASSWORD ***2014-09-23 23:04:31  INFO    OGG-03500  WARNING: NLS_LANG environment variable does not match database character set, or not set. Using database character set value of ZHS16GBK.DBOPTIONS ALLOWNOLOGGINGRmtHost 192.168.1.3, mgrport 7809RmtTask Replicat, Group DHREMD1Table HR.T;2014-09-23 23:04:46  WARNING OGG-00869  No unique key is defined for table ‘T‘. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.Using the following key columns for source table HR.T: EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID.2014-09-23 23:04:46  INFO    OGG-01815  Virtual Memory Facilities for: COM    anon alloc: mmap(MAP_ANON)  anon free: munmap    file alloc: mmap(MAP_SHARED)  file free: munmap    target directories:    /home/oracle/ogg/dirtmp.CACHEMGR virtual memory values (may have been adjusted)CACHESIZE:                               64GCACHEPAGEOUTSIZE (normal):                8MPROCESS VM AVAIL FROM OS (min):         128GCACHESIZEMAX (strict force to disk):     96GDatabase Version:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionPL/SQL Release 11.2.0.1.0 - ProductionCORE    11.2.0.1.0      ProductionTNS for Linux: Version 11.2.0.1.0 - ProductionNLSRTL Version 11.2.0.1.0 - ProductionDatabase Language and Character Set:NLS_LANG         = ".ZHS16GBK" NLS_LANGUAGE     = "AMERICAN" NLS_TERRITORY    = "AMERICA" NLS_CHARACTERSET = "ZHS16GBK" 2014-09-23 23:04:51  INFO    OGG-01021  Command received from GGSCI: STATS.Processing table HR.T************************************************************************                   ** Run Time Statistics **                         ************************************************************************Report at 2014-09-23 23:04:57 (activity since 2014-09-23 23:04:46)Output to DHREMD1:From Table HR.T:       #                   inserts:       107       #                   updates:         0       #                   deletes:         0       #                  discards:         0REDO Log Statistics  Bytes parsed                    0  Bytes output                24570