Database/Oracle (1) 썸네일형 리스트형 Oracle GoldenGate, Oracle Database 설정 Source Database 설정 supplemental log data 생성하기 -- SUPPLEMENTAL LOG ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE) COLUMNS; ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS; ALTER DATABASE ADD SUPPLEMENTAL LOG DATA ( ALL ) COLUMNS; 반대로 삭제하고 싶을때 ALTER DATABASE DROP SUPPLEMENTAL LOG DATA (ALL) COLUMNS; ALTER DATABASE DROP SUPPLE.. 이전 1 다음