목차
- 제목 및 저작권 정보
- 머리말
- Oracle GoldenGate
- Oracle GoldenGate 매개변수
GLOBALS매개변수 요약- 추출 매개변수 요약
- Replicat 매개변수 요약
ABORTDISCARDRECSALLOCFILESALLOWDUPTARGETMAP|NOALLOWDUPTARGETMAPALLOWINVISIBLEINDEXKEYSALLOWNULLABLEKEYS|NOALLOWNULLABLEKEYSALLOWNONVALIDATEDKEYSALLOWNOOPUPDATES|NOALLOWNOOPUPDATESAPPLYNOOPUPDATES|NOAPPLYNOOPUPDATESAPPLY_PARALLELISM|MAX_APPLY_PARALLELISM|MIN_APPLY_PARALLELISMASCIITOEBCDICASSUMETARGETDEFSAUTOSCHEMAOPTIONSBATCHSQLBEGINBLOBMEMORYBINARY_JSON_FORMATBRCACHEMGRCATALOGEXCLUDECHARMAPCHECKPARAMSCHECKPOINTSECSCHECKPOINTTABLECHUNK_SIZECMDTRACECOLCHARSETCOLMATCHCOMPRESSDELETES|NOCOMPRESSDELETESCOMPRESSUPDATES|NOCOMPRESSUPDATESCOMMIT_SERIALIZATIONCOORDSTATINTERVALCOORDTIMERCRYPTOENGINECUSEREXITDBOPTIONSDDLDDLERRORDDLOPTIONSDDLSUBSTDDLTABLEDECRYPTTRAILDEFERAPPLYINTERVALDEFSFILEDIAGLOGRECSDICTIONARY_CACHE_SIZEDISCARDFILE|NODISCARDFILEDISCARDROLLOVERDYNAMICRESOLUTION|NODYNAMICRESOLUTIONEBCDICTOASCIIENABLEMONITORINGENABLE_HEARTBEAT_TABLE|DISABLE_HEARTBEAT_TABLEENCRYPTTRAIL|NOENCRYPTTRAILENDEOFDELAY|EOFDELAYCSECSEXCLUDEHIDDENCOLUMNSEXCLUDETAGEXCLUDEWILDCARDOBJECTSONLYEXTFILEEXTRACTEXTTRAILFETCHOPTIONSFETCHUSERIDALIASFILTERDUPS|NOFILTERDUPSFILEGROUPFLUSHSECS|FLUSHCSECSFUNCTIONSTACKSIZEGETDELETES|IGNOREDELETESGETINSERTS|IGNOREINSERTSGETTRUNCATES|IGNORETRUNCATESGETUPDATEAFTERS|IGNOREUPDATEAFTERSGETUPDATEBEFORES|IGNOREUPDATEBEFORESGETUPDATES|IGNOREUPDATESGGSCHEMAGROUPTRANSOPSHANDLECOLLISIONS|NOHANDLECOLLISIONSHAVEUDTWITHNCHARHEARTBEATTABLEINCLUDEINCLUDETAGINITIALLOADOPTIONSINSERTALLRECORDSINSERTAPPEND|NOINSERTAPPENDINSERTDELETES|NOINSERTDELETESINSERTMISSINGUPDATES|NOINSERTMISSINGUPDATESINSERTUPDATES|NOINSERTUPDATESINSERTUPSERTS|NOINSERTUPSERTSLIST|NOLISTLOGALLSUPCOLSLOOK_AHEAD_TRANSACTIONSLOGOUT_RECV_TIMEOUTLRSNTIMEDELTAMACROMACROCHAR- 추출용
MAP MAPMAPALLCOLUMNS|NOMAPALLCOLUMNSMAP_PARALLELISMMAPEXCLUDEMAPINVISIBLECOLUMNS|NOMAPINVISIBLECOLUMNSMASTERKEYNAMEMAXDISCARDRECSMAXGROUPSMAXSQLSTATEMENTSMAXTRANSOPSMGRSERVNAMENAMECCSIDNAMEMATCH매개변수NLS_LENGTH_SEMANTICSNOCATALOGNODUPMSGSUPPRESSIONNUMFILESNOUSERIDOBEYOUTPUTFILEUMASKOUTPUTFORMATOVERRIDEDUPS|NOOVERRIDEDUPSPARTITION|PARTITIONEXCLUDEPTKMONITORFREQUENCYPRESERVETARGETTIMEZONEPROCEDUREREPERRORREPFETCHEDCOLOPTIONSREPLACEBADCHARREPLACEBADNUMREPLICATREPORTREPORTCOUNTREPORTROLLOVERRESTARTCOLLISIONS|NORESTARTCOLLISIONSRMTFILEROLLOVERRMTTRAILSCHEMAEXCLUDESEQUENCESESSIONCHARSETSETENVSOURCECATALOGSOURCECHARSETSOURCEDEFSSOURCEISTABLESOURCETIMEZONESPACESTONULL|NOSPACESTONULLSPECIALRUNSPLIT_TRANS_RECSSQLDUPERRSQLEXECSTATOPTIONSTABLE|MAPDEFGEN의 경우TABLE- Replicat의 경우
TABLE TABLEEXCLUDETARGETDDLNOTIFY|NOTARGETDDLNOTIFYTARGETDEFSTCPSOURCETIMER|NOTCPSOURCETIMERTRAILBYTEORDERTRAILCHARSETTRAILCHARSETASCIITRAILCHARSETEBCDICTRANLOGOPTIONSTRANSACTIONTIMEOUTTRIMSPACES|NOTRIMSPACESTRIMVARSPACES|NOTRIMVARSPACESUPDATEDELETES|NOUPDATEDELETESUPDATEINSERTS|NOUPDATEINSERTSUPDATERECORDFORMATUSEDEDICATEDCOORDINATIONTHREADUSEIPV4|USEIPV6USERIDALIASVARWIDTHNCHAR|NOVARWIDTHNCHARWARNLONGTRANSWARNRATEWILDCARDRESOLVEY2KCENTURYADJUSTMENT|NOY2KCENTURYADJUSTMENT
- 테이블 및 열 매핑 함수
- 열-변환 함수 요약
@AISERVICE@RANGE@AFTER@BEFORE@BEFOREAFTER@BINARY@BINTOBASE64@BINTOHEX@CASE@COLSTAT@COLTEST@COMPUTE@DATE@DBFUNCTION@DATEDIFF@DATENOW@DDL@EVAL@GETENV@GETVAL@HEXTOBIN@HIGHVAL|LOWVAL@IF@NUMBIN@NUMSTR@OGG_SHA1@STRCAT@STRCMP@STRCMPNULL@STREQ@STREQNULL@STREXT@STRFIND@STRLEN@STRLTRIM@STRNCAT@STRNCMP@STRNUM@STRRTRIM@STRSUB@STRTRIM@STRUP@TOKEN@VALONEOF
- 사용자 종료 함수
- 사용자 종료 함수 요약
- 유저 종료 호출
EXIT_CALL_TYPE사용EXIT_CALL_RESULT사용EXIT_PARAMS사용ERCALLBACK사용- 함수 코드
COMPRESS_RECORDDECOMPRESS_RECORDGET_BASE_OBJECT_NAMEGET_BASE_OBJECT_NAME_ONLYGET_BASE_SCHEMA_NAME_ONLYGET_BEFORE_AFTER_INDGET_CATALOG_NAME_ONLYGET_COL_METADATA_FROM_INDEXGET_COL_METADATA_FROM_NAMEGET_COLUMN_INDEX_FROM_NAMEGET_COLUMN_NAME_FROM_INDEXGET_COLUMN_VALUE_FROM_INDEXGET_COLUMN_VALUE_FROM_NAMEGET_DATABASE_METADATAGET_DDL_RECORD_PROPERTIESGLOSSARYGET_ENV_VALUEGET_ERROR_INFOGET_GMT_TIMESTAMPGET_MARKER_INFOGET_OBJECT_NAMEGET_OBJECT_NAME_ONLYGET_OPERATION_TYPEGET_POSITIONGET_RECORD_BUFFERGET_RECORD_LENGTHGET_RECORD_TYPEGET_SCHEMA_NAME_ONLYGET_SESSION_CHARSETGET_STATISTICSGET_TABLE_COLUMN_COUNTGET_TABLE_METADATAGET_TABLE_NAMEGET_TABLE_NAME_ONLYGET_TIMESTAMPGET_TRANSACTION_INDGET_USER_TOKEN_VALUEOUTPUT_MESSAGE_TO_REPORTRESET_USEREXIT_STATSSET_COLUMN_VALUE_BY_INDEXSET_COLUMN_VALUE_BY_NAMESET_OPERATION_TYPESET_RECORD_BUFFERSET_SESSION_CHARSETSET_TABLE_NAME
- Oracle GoldenGate 프로그램