ogg增加表

步骤：
stop ESOURCE
stop PSOURCE
$ pwd
/zyhome/oracle/ogg/dirprm
$ ls
esource.prm  mgr.prm      psource.prm
$vi esource.prm


TABLE GISTAR.RM_PRODUCT_OSS;


GGSCI>dblogin userid oggadm, password oggadm
add trandata GISTAR.RM_PRODUCT_OSS


ftp 172.18.20.33
exp gistar/gistar file=rm_product_oss.dmp log=rm_product_oss.log tables=rm_product_oss  buffer=209715200 direct=y recordlength=65535 triggers=no
imp gistar/gistar file=rm_product_oss.dmp log=rm_product_oss_imp.log tables=rm_product_oss  buffer=209715200 feedback=50000 recordlength=65535 CONSTRAINTS=no 




start ESOURCE
start PSOURCE 


select count（*） from rm_product_oss；