[Database] UNIX- 오라클 테이블 SAM 내리기

1. dumper.c 수정하기
dumper.c 중에서

#include <time.h>

/* Oracle Type definitions, such as TRUE, FALSE sb1 etc. */
#include "/ORACLE/INF/app/oracle/product/9.2.0/rdbms/demo/oratypes.h"

/* LDA and CDA struct declarations */
#include "/ORACLE/INF/app/oracle/product/9.2.0/rdbms/demo/ocidfn.h"

/* ANSI-style function declarations/prototypes */
#include "/ORACLE/INF/app/oracle/product/9.2.0/rdbms/demo/ocikpr.h"

* ORACLE_HOME 을 적절하게 수정한다.


2. dumper 실행 파일 만들기

[sysdba01@infodb1 /EXP/SAM/SAM/VER]$ cat  dumper.mk.32bit.ibm
#export OBJECT_MODE=32 (for aix)
export LD_LIBRARY_PATH=/ORACLE/TST/app/oracle/product/9.2.0/lib:/ORACLE/TST/app/oracle/product/9.2.0/lib32:/usr/lib
#SQLLIB=" -lclntsh -lcommon -lcore4 -lnlsrtl3 "
cc -I$ORACLE_HOME/precomp/public -I$ORACLE_HOME/rdbms/demo -L$ORACLE_HOME/lib32 -lclntsh -lclntst9 -lpthreads -lodm  dumper.c -o dumper
#cc -I$ORACLE_HOME/precomp/public -I$ORACLE_HOME/rdbms/demo $SQLLIB -lpthread dumper.c -o dumper


3. 소스 테이블 선정하기

[sysdba01@infodb1 /EXP/SAM/SAM]$ cat target_tbl
TBFKK001
TBFKD002

4. owner 선정하기

[sysdba01@infodb1 /EXP/SAM/SAM]$ more  gen_ctl_main.sh
# *****************************************************************************
# Gen DDL :  Generate Shell Control File and Main Shell Script Using target_tbl
# *****************************************************************************

# -----------------------------------------------------------------------------
# >>>>>>>>>>>>> You Must Editing Shell Variable Below for Your Site <<<<<<<<<<<
# -----------------------------------------------------------------------------

SH_TARGET_TAB_FILE=./target_tbl              # Describe Table List File to Send

SH_SAMFILE_PATH=./CSV

# SH_SAMFILE_PATH=`pwd`
# SH_SAMFILE_PATH=/ettfs01/csv_qm

SH_DB_OWNER=DONGBU

SH_DB_USER=SVRCON
SH_DB_PASSWD=SVRCON

5. gen_ctl_main.sh 실행하여 dumper_YYYYMMDD.HHMM.sh 만들기
# sh gen_ctl_main.sh

6. dumper_YYYYMMDD.HHMM.sh  실행하기

* delimiter 는 dumper.c 중에 COMMA 부분으로 적절하게 수정함