2024年最全Oracle GoldenGate（OGG）- 超级详细，Golang开发中常见的一些问题面试专题

于 2024-05-11 13:00:05 发布
阅读量968 收藏 19
点赞数 20
分类专栏： 程序员 文章标签： go 学习 面试
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/2401_84931473/article/details/138710979
版权

img
img

网上学习资料一大堆，但如果学到的知识不成体系，遇到问题时只是浅尝辄止，不再深入研究，那么很难做到真正的技术提升。

需要这份系统化的资料的朋友，可以添加戳这里获取

一个人可以走的很快，但一群人才能走的更远！不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人，都欢迎加入我们的的圈子（技术交流、学习资源、职场吐槽、大厂内推、面试辅导），让我们一起学习成长！

unzip /export/softwares/oracle/ogg/V971332-01.zip -d /export/softwares/oracle/ogg/tgr/

在这里插入图片描述

cd /export/softwares/oracle/ogg/tgr/

在这里插入图片描述
ggs_Adapters_Linux_x64.tar文件是真正的OGG目标端软件包，解压该文件到/u01/app/ogg/tgr目录下，执行命令：

tar -xf ggs_Adapters_Linux_x64.tar -C /u01/app/ogg/tgr/
  • 配置/u01/app/ogg/tgr目录及其所有文件的权限
    解压后的默认用户和组
    在这里插入图片描述
    使用root用户执行授权命令：
chown -R oracle:oinstall /u01/app/ogg/tgr

在这里插入图片描述
可以看到/u01/app/ogg/目录下的tgr属于oracle用户和oinstall组。

ll /u01/app/ogg/tgr

在这里插入图片描述
可以看到/u01/app/ogg/tgr目录下的所有文件都属于oracle用户和oinstall组。

7.4.2 OGG目标端初始化
  • 使用oracle用户登录目标端OGG的命令行中
    可以看到/u01/app/ogg/目录下的tgr属于oracle用户和oinstall组。
su oracle

切换oracle用户时需要重新加载环境变量：

source ~/.bash_profile 
cd $OGG\_TGR\_HOME
./ggsci

在这里插入图片描述

  • 初始化目标端OGG目录
    注意：如果不在OGG_TGR_HOME下，初始化目标端OGG目录时会报错
create subdirs

在这里插入图片描述
退出OGG命令行客户端：exit

  • 检查目标端OGG初始化后的目录
    初始化完成后，可以查询在$OGG_TGR_HOME下是否存在dirchk、dircrd、dirdat、dirdef、dirdmp、diretc、dirout、dirpcs、dirprm、dirrpt、dirsql、dirtmp、dirwlt、dirwww共14个目录。
7.4.3 拷贝源端的define文件到目标端

将生成的/u01/app/ogg/src/dirdef/test_ogg.test_ogg发送的目标端ogg目录下的dirdef里：

scp -r $OGG\_SRC\_HOME/dirdef/test_ogg.test_ogg $OGG\_TGR\_HOME/dirdef/
7.4.4 安装zookeeper和Kafka
  • 安装ZooKeeper(使用root用户操作)
    解压：
tar -zxf /export/softwares/zookeeper-3.4.14.tar.gz -C /export/services/

创建软连接：

ln -s /export/services/zookeeper-3.4.14 /export/services/zookeeper

创建zoo.cfg：

cp /export/services/zookeeper/conf/zoo_sample.cfg /export/services/zookeeper/conf/zoo.cfg

配置zoo.cfg：

vim /export/services/zookeeper/conf/zoo.cfg

tickTime=2000
initLimit=10
syncLimit=5
dataDir=/export/datas/zookeeper/data
dataLogDir=/export/datas/zookeeper/log
clientPort=2181

创建ZooKeeper的数据路径：

mkdir -p /export/datas/zookeeper/data
mkdir -p /export/datas/zookeeper/log

添加到环境变量：

vim /etc/profile

export ZOOKEEPER_HOME=/export/services/zookeeper
export PATH=.: Z O O K E E P E R _ H O M E / b i n : ZOOKEEPER\_HOME/bin: ZOOKEEPER_HOME/bin:JAVA_HOME/bin: J A V A _ H O M E / j r e / b i n : JAVA\_HOME/jre/bin: JAVA_HOME/jre/bin:PATH

source /etc/profile

启动ZooKeeper：

zkServer.sh start
zkServer.sh status
  • 安装kafka(使用root用户操作)
    解压：
tar -zxf /export/softwares/kafka_2.11-2.2.0.tgz  -C /export/services/

创建软连接：

ln -s /export/services/kafka_2.11-2.2.0 /export/services/kafka

配置server.prperties：

vim /export/services/kafka/config/server.properties

listeners=PLAINTEXT://server01:9092
broker.id=0
zookeeper.connect=server01:2181

添加环境变量：

vim /etc/profile


export KAFKA_HOME=/export/services/kafka
export PATH=.:$KAFKA\_HOME/bin:$ZOOKEEPER\_HOME/bin:$JAVA\_HOME/bin:$JAVA\_HOME/jre/bin:$PATH


source /etc/profile

启动Kafka：

kafka-server-start.sh -daemon /export/services/kafka/config/server.properties

创建主题：

kafka-topics.sh --create --zookeeper server01:2181 --replication-factor 1 --partitions 1 --topic test_ogg

查看主题：

kafka-topics.sh --list --zookeeper server01:2181
7.4.5 配置管理器MRG进程

使用oracle用户进入OGG_SRC_HOME目录下
切换到oracle用户下：

su – oracle

打印目标端OGG_TGR_HOME：

echo $OGG\_TGR\_HOME

进入OGG_TGR_HOME：

cd $OGG\_TGR\_HOME

启动ggsci：

./ggsci

配置目标端MRG进程
配置MGR进程：

edit param mgr

新增内容：

PORT 7810
DYNAMICPORTLIST 7810-7909
AUTORESTART EXTRACT *,RETRIES 5,WAITMINUTES 3
PURGEOLDEXTRACTS ./dirdat/*,usecheckpoints, minkeepdays 3

在这里插入图片描述

7.4.6 配置checkpoint
edit param ./GLOBALS

新增内容：

CHECKPOINTTABLE test_ogg.checkpoint

在这里插入图片描述

7.4.7 配置Replicate进程

配置目标端Replicate进程
配置replicate进程：

edit param rekafka

REPLICAT rekafka
sourcedefs /u01/app/ogg/tgr/dirdef/test_ogg.test_ogg
TARGETDB LIBFILE libggjava.so SET property=dirprm/kafka.props
REPORTCOUNT EVERY 1 MINUTES, RATE
GROUPTRANSOPS 10000
MAP test_ogg.test_ogg, TARGET test_ogg.test_ogg;

在这里插入图片描述

7.4.8 添加trail文件到replicate进程

添加trail文件到Replicate进程

add replicat rekafka exttrail /u01/app/ogg/tgr/dirdat/to,checkpointtable test_ogg.checkpoint

在这里插入图片描述

7.4.9 配置kafka.props
  • 配置kafka.props
cd $OGG\_TGR\_HOME
vim dirprm/kafka.props

新增内容：

gg.handlerlist=kafkahandler
gg.handler.kafkahandler.type=kafka
gg.handler.kafkahandler.KafkaProducerConfigFile=custom_kafka_producer.properties
gg.handler.kafkahandler.topicMappingTemplate=test_ogg
gg.handler.kafkahandler.format=json
gg.handler.kafkahandler.mode=op
gg.classpath=dirprm/:/export/services/kafka/libs/*:/u01/app/ogg/tgr/:/u01/app/ogg/tgr/lib/*

在这里插入图片描述

  • 配置custom_kafka_producer.properties
cd $OGG\_TGR\_HOME
vim dirprm/custom_kafka_producer.properties

新增内容：

bootstrap.servers=server01:9092
acks=1
compression.type=gzip
reconnect.backoff.ms=1000
value.serializer=org.apache.kafka.common.serialization.ByteArraySerializer
key.serializer=org.apache.kafka.common.serialization.ByteArraySerializer
batch.size=102400
linger.ms=10000

在这里插入图片描述

7.4.10 最后确认所有的进程

在目标端，主要做了4个操作，共包括2个进程，分别是MANAGER和REPLICAT。
在这里插入图片描述

7.5 OGG测试

7.5.1 启动OGG的源端和目标端

前提：切换到 oracle 账号且启动了 Oracle
注意：要严格按照启动顺序执行：

  • 第一步：启动源端mgr进程
  • 第二步：启动目标端mgr进程
  • 第三步：启动源端extract进程
  • 第四步：启动源端pump进程
  • 第五步：启动目标端replicate进程
  1. 启动源端mgr进程
cd $OGG\_SRC\_HOME
./ggsci
#查看所有进程状态：
info all
#启动MANAGER进程：
start mgr
#检查所有进程状态：
info all

在这里插入图片描述

  1. 启动目标端mgr进程
cd $OGG\_TGR\_HOME
./ggsci

#启动MANAGER进程：
start mgr
#查看所有进程状态：
info all

在这里插入图片描述
3. 启动源端extract进程

cd $OGG\_SRC\_HOME
./ggsci
#启动EXTRACT进程：
start extkafka
#查看所有进程状态：
info all

在这里插入图片描述

  1. 启动源端pump进程
    启动pump进程：
start pukafka

查看所有进程状态：

info all

在这里插入图片描述

  1. 启动目标端replicat进程
cd $OGG\_TGR\_HOME
./ggsci

启动replicat进程：

start rekafka

查看所有进程状态：

info all

在这里插入图片描述

  1. 确认源端和目标端进程运行情况
    源端：
    在这里插入图片描述
    目标端：
    在这里插入图片描述
7.5.2 测试OGG的数据采集
  • 使用oracle用户登录到oracle11g数据库(源端)
su – oracle
sqlplus "/as sysdba"
conn test_ogg/test_ogg

在这里插入图片描述

  • 对表进行DML操作(每一条SQL都需要手动执行commit提交)
    登录到test_ogg用户下：
conn test_ogg/test_ogg

在这里插入图片描述
查看该用户拥有的表：

select table_name from user_tables;

在这里插入图片描述
查看TEST_OGG表的字段信息：

select column_name,data_type from user_tab_columns where table_name = upper('TEST\_OGG');

在这里插入图片描述
插入数据：

insert into test_ogg values(1,'beijing');

在这里插入图片描述
执行Commit：

commit;

在这里插入图片描述
查看kafka是否多出了一个叫做test_ogg的主题：

kafka-topics.sh --list --zookeeper server01:2181

在这里插入图片描述
然后启动kafka的消费者来消费test_ogg主题的数据：

kafka-console-consumer.sh --bootstrap-server server01:9092 --topic test_ogg --from-beginning

再查看kafka的test_ogg主题下是否有了数据：
在这里插入图片描述
执行修改数据(修改id=2的name为china-shanghai)：

update test_ogg set name='china-shanghai' where id=2;

在这里插入图片描述
查看kafka中是否有了id为2的china-shanghai的这条记录：
在这里插入图片描述
删除id为2的数据：

delete test_ogg where id=2;

在这里插入图片描述
检查kafka是否多个一条被标记为删除的数据：
在这里插入图片描述

:{"table":"TEST\_OGG.TEST\_OGG","op\_type":"I","op\_ts":"2020-05-28 09:22:18.000129",
{"table":"TEST\_OGG.TEST\_OGG","op\_type":"U","op\_ts":"2020-05-28 09:25:17.000140","current\_ts":"2020-05-28T09:25:22.085000","pos":"00000000000000001227","before":{},"after":{"ID":1,"NAME":"china-shanghai"}}
  • 关于数据文件的检查
    如果数据库中发生了事务(都被commit后)操作，会在源端和目标端的dirdat下生成trail数据文件。数据文件名称只能使用2个字母，多了会报错。
    当源端发生事务后，检查源端的trail文件：
ll /u01/app/ogg/src/dirdat/

在这里插入图片描述
目标端会接收到源端pump进程传过来的数据文件：

ll /u01/app/ogg/tgr/dirdat/

在这里插入图片描述

7.5.3 注意事项
  • 必须严格遵守OGG的启动顺序；
  • 必须严格遵守OGG的关闭顺序；
  • 如果需要修改OGG的进程，必须先停止，修改成功后，再重启；
7.5.4 错误日志位置

源端错误日志路径

/u01/app/ogg/src/ggserr.log

目标端错误日志路径

/u01/app/ogg/tgr/ggserr.log

8. 初始化业务数据

8.1 安装OGG源端

8.1.1 在Oracle中创建OGG相关的用户和表空间
  1. 创建表空间在磁盘中的物理路径（需要到root用户操作）
mkdir -p /u01/app/oracle/oggdata/orcl/
chown -R oracle:oinstall /u01/app/oracle/oggdata/orcl
  1. 进入sqlplus
    切换到oracle用户：su - oracle
    登录sqlplus：
sqlplus "/as sysdba"
  1. 创建oggtbs表空间
CREATE TABLESPACE "TBS\_LOGISTICS" DATAFILE '/u01/app/oracle/oradata/orcl/tbs\_logistics.dat' SIZE 500M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

在这里插入图片描述

  1. 创建erainm用户(用户名和密码都是erainm)
CREATE USER erainm IDENTIFIED BY erainm DEFAULT TABLESPACE TBS_LOGISTICS;

在这里插入图片描述

  1. 赋予erainm用户dba权限
GRANT connect,resource,dba to erainm;

在这里插入图片描述

8.1.2 OGG源端初始化
  1. 使用oracle用户登录源端OGG的命令行中
su – oracle
cd $OGG\_SRC\_HOME
./ggsci

在这里插入图片描述

初始化源端OGG目录
注意：如果不在OGG_SRC_HOME下，初始化OGG目录时会报错

create subdirs

在这里插入图片描述
退出OGG命令行客户端：exit

  1. 检查源端OGG初始化后的目录
    初始化完成后，可以查询在$OGG_SRC_HOME下是否存在dirchk、dirdat、dirdef、dirjar、dirout、dirpcs、dirprm、dirrpt、dirsql、dirtmp共11个目录。
    在这里插入图片描述

8.2 配置OGG源端

8.2.1 Oracle创建项目相关表
属性名属性值
主机地址192.168.88.10
端口号1521
数据库实例名称ORCL
数据库实例类型Service Name
用户名erainm
角色Normal
密码erainm
JDBC访问URLjdbc:oracle:thin:@//192.168.88.10:1521:ORCL
JDBC驱动名称使用OracleDataSource连接池，无需配置Driver
-- 创建所有的序列
CREATE SEQUENCE tbl_emp_info_map_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_driver_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_emp_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_warehouse_tt_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_charge_standard_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_company_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_company_dot_map_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_company_route_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_company_warehouse_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_courier_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_deliver_region_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_delivery_record_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_department_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_fixed_area_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_goods_rack_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_job_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_out_warehouse_dtl_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_pkg_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_postal_standard_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_push_warehouse_dtl_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_service_evaluation_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_store_grid_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_vehicle_monitor_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_warehouse_rack_map_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_warehouse_receipt_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_waybill_line_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_waybill_record_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_work_time_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_test_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_areas_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_deliver_package_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_customer_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_codes_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_warehouse_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_consumer_address_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_warehouse_receipt_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_warehouse_send_vehicle_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_warehouse_vehicle_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_dot_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_transport_tool_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_dot_transport_tool_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_address_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_route_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_push_warehouse_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_out_warehouse_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_warehouse_emp_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_express_package_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_express_bill_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_consumer_sender_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_collect_package_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;
CREATE SEQUENCE tbl_waybill_id_seq INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999999999999999;

-- 创建所有的业务表
CREATE TABLE "tbl\_emp\_info\_map" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"company\_id" NUMBER(19,0), 
"dot\_id" NUMBER(19,0), 
"emp\_id" NUMBER(19,0), 
"job\_id" NUMBER(19,0), 
"dep\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
CONSTRAINT "PK\_TBL\_EMP\_INFO\_MAP" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS";

CREATE TABLE "tbl\_driver" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"job\_number" NVARCHAR2(50), 
"name" NVARCHAR2(50), 
"gender" NVARCHAR2(100),
"birathday" DATE, 
"state" NUMBER(19,0), 
"driver\_license\_number" NVARCHAR2(100), 
"driver\_license\_type" NUMBER(19,0), 
"get\_driver\_license\_dt" DATE, 
"car\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_DRIVER" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_emp" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"emp\_number" NVARCHAR2(50), 
"emp\_name" NVARCHAR2(50), 
"emp\_gender" NUMBER(10,0), 
"emp\_birathday" DATE, 
"state" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_EMP" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_warehouse\_transport\_tool" (  
"id" NUMBER(19,0) NOT NULL ENABLE, 
"warehouse\_id" NUMBER(19,0), 
"transport\_tool\_id" NUMBER(19,0), 
"allocate\_dt" DATE, 
"state" NUMBER(10,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_WAREHOUSE\_TRANSPORT\_TOOL" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_charge\_standard" (   
"id" NUMBER(19,0) NOT NULL ENABLE, 
"start\_area\_id" NUMBER(19,0), 
"stop\_area\_id" NUMBER(19,0), 
"first\_weight\_charge" NUMBER(19,0), 
"follow\_up\_weight\_charge" NUMBER(19,0), 
"prescription" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_CHARGE\_STANDARD" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS";

CREATE TABLE "tbl\_company" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"company\_name" NVARCHAR2(50), 
"city\_id" NUMBER(19,0), 
"company\_number" NVARCHAR2(50), 
"company\_addr" NVARCHAR2(100), 
"company\_addr\_gis" NVARCHAR2(100), 
"company\_tel" NVARCHAR2(20), 
"is\_sub\_company" NUMBER(19,0), 
"state" NUMBER(10,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_COMPANY" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS";

CREATE TABLE "tbl\_company\_dot\_map" (   
"id" NUMBER(19,0) NOT NULL ENABLE, 
"company\_id" NUMBER(19,0), 
"dot\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_COMPANY\_DOT\_MAP" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_company\_transport\_route\_ma" 
(
"id" NUMBER(19,0) NOT NULL ENABLE, 
"company\_id" NUMBER(19,0), 
"transport\_route\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_COMPANY\_TRANSPORT\_ROUTE" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_company\_warehouse\_map" ( 
"id" NUMBER(19,0) NOT NULL ENABLE, 
"company\_id" NUMBER(19,0), 
"warehouse\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_COMPANY\_WAREHOUSE\_MAP" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_courier" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"job\_num" NVARCHAR2(50), 
"name" NVARCHAR2(50), 
"birathday" DATE, 
"tel" NVARCHAR2(20), 
"pda\_num" NVARCHAR2(50), 
"car\_id" NUMBER(19,0), 
"postal\_standard\_id" NUMBER(19,0), 
"work\_time\_id" NUMBER(19,0), 
"dot\_id" NUMBER(19,0), 
"state" NUMBER(10,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_COURIER" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_deliver\_region" 
(
"id" NUMBER(19,0) NOT NULL ENABLE, 
"search\_keyword" NVARCHAR2(100), 
"search\_assist\_keyword" NVARCHAR2(100), 
"area\_id" NUMBER(19,0), 
"fixed\_area\_id" NUMBER(19,0), 
"state" NUMBER(10,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_DELIVER\_REGION" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_delivery\_record" (   
"id" NUMBER(19,0) NOT NULL ENABLE, 
"cur\_warehouse\_id" NVARCHAR2(50), 
"vehicle\_id" NUMBER(19,0), 
"start\_vehicle\_dt" DATE,
"next\_warehouse\_id" NUMBER(19,0), 
"predict\_arrivals\_dt" DATE,
"actua\_arrivals\_dt" DATE,
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_DELIVERY\_RECORD" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_department" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"dep\_name" NVARCHAR2(50), 
"dep\_level" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_DEPARTMENT" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_fixed\_area" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"name" NVARCHAR2(50), 
"emp\_id" NUMBER(19,0), 
"operator\_dt" DATE, 
"operator\_id" NUMBER(19,0), 
"gis\_fence" NVARCHAR2(200), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_FIXED\_AREA" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_goods\_rack" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"warehouse\_name" NVARCHAR2(50), 
"warehouse\_addr" NVARCHAR2(100),
"warehouse\_addr\_gis" NVARCHAR2(50), 
"company\_id" NUMBER(19,0), 
"employee\_id" NVARCHAR2(200), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_GOODS\_RACK" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_job" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"job\_name" NVARCHAR2(50), 
"job\_level" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_JOB" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_out\_warehouse\_detail" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"push\_warehouse\_id" NUMBER(19,0), 
"push\_warehouse\_bill" NVARCHAR2(100), 
"warehouse\_id" NUMBER(19,0), 
"waybill\_id" NUMBER(19,0), 
"pkg\_id" NUMBER(19,0), 
"pkg\_desc" NVARCHAR2(100), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_OUT\_WAREHOUSE\_DETAIL" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_pkg" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"pw\_bill" NVARCHAR2(50), 
"pw\_dot\_id" NUMBER(19,0), 
"warehouse\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_PKG" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_postal\_standard" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"name" NVARCHAR2(50), 
"min\_weight" NVARCHAR2(50), 
"min\_length" NVARCHAR2(50), 
"max\_length" NVARCHAR2(50), 
"trajectory" NVARCHAR2(50), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_POSTAL\_STANDARD" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_push\_warehouse\_detail" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"push\_warehouse\_id" NUMBER(19,0), 
"push\_warehouse\_bill" NVARCHAR2(50), 
"warehouse\_id" NUMBER(19,0), 
"pw\_start\_dt" NVARCHAR2(50), 
"pw\_end\_dt" NVARCHAR2(50), 
"pack\_id" NUMBER(19,0), 
"pack\_desc" NVARCHAR2(50), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_PUSH\_WAREHOUSE\_DETAIL" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_service\_evaluation" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"express\_bill\_id" NVARCHAR2(100), 
"express\_bill" NUMBER(19,0), 
"pack\_score" NUMBER(10,0), 
"delivery\_time\_score" NUMBER(10,0), 
"courier\_score" NUMBER(10,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_SERVICE\_EVALUATION" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_store\_grid" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"warehouse\_name" NVARCHAR2(50), 
"warehouse\_addr" NVARCHAR2(100),
"warehouse\_addr\_gis" NVARCHAR2(50), 
"company\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_STORE\_GRID" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_vehicle\_monitor" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"delivery\_record" NUMBER(19,0), 
"empId" NUMBER(19,0), 
"express\_bill\_\_id" NVARCHAR2(200), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_VEHICLE\_MONITOR" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_warehouse\_rack\_map" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"warehouse\_name" NVARCHAR2(50), 
"warehouse\_addr" NVARCHAR2(100),
"warehouse\_addr\_gis" NVARCHAR2(50), 
"company\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_WAREHOUSE\_RACK\_MAP" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_warehouse\_receipt\_detail" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"waybill\_id" NUMBER(19,0), 
"pkg\_id" NUMBER(19,0), 
"receipt\_bill\_id" NUMBER(19,0), 
"receipt\_bill" NVARCHAR2(100), 
"operator\_id" NUMBER(19,0), 
"state" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_WAREHOUSE\_RECEIPT\_DETAI" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_waybill\_line" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"waybill\_number" NVARCHAR2(100), 
"route\_id" NUMBER(19,0), 
"serial\_number" NVARCHAR2(100), 
"transport\_tool" NUMBER(19,0), 
"delivery\_record\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_WAYBILL\_LINE" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_waybill\_state\_record" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"waybill\_id" NUMBER(19,0), 
"waybill\_number" NVARCHAR2(100), 
"employee\_id" NVARCHAR2(100), 
"consignee\_id" NUMBER(19,0), 
"cur\_warehouse\_id" NUMBER(10,0), 
"next\_warehouse\_id" NUMBER(10,0), 
"deliverer\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_WAYBILL\_STATE\_RECORD" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_work\_time" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"name" NVARCHAR2(50), 
"start\_dt" NVARCHAR2(100),
"stop\_dt" NVARCHAR2(100),
"saturday\_start\_dt" NVARCHAR2(100),
"saturday\_stop\_dt" NVARCHAR2(100),
"sunday\_start\_dt" NVARCHAR2(100),
"sunday\_stop\_dt" NVARCHAR2(100),
"state" NUMBER(10,0), 
"company\_id" NUMBER(10,0), 
"operator\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_WORK\_TIME" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_test" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"name" NVARCHAR2(50), 
 CONSTRAINT "PK\_TBL\_TEST" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_areas" (
"id" NUMBER(11,0) NOT NULL ENABLE, 
"name" NVARCHAR2(40), 
"pid" NUMBER(11,0), 
"sname" NVARCHAR2(40), 
"level" NVARCHAR2(11), 
"citycode" NVARCHAR2(20), 
"yzcode" NVARCHAR2(20), 
"mername" NVARCHAR2(100), 
"lng" NUMBER(11,4), 
"lat" NUMBER(11,4), 
"pinyin" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_AREAS" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_deliver\_package" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"emp\_id" NUMBER(19,0), 
"waybill\_id" NUMBER(19,0), 
"waybill\_number" NVARCHAR2(100), 
"express\_bill\_id" NUMBER(19,0), 
"express\_bill\_number" NVARCHAR2(100), 
"package\_id" NUMBER(19,0), 
"collect\_package\_dt" DATE, 
"rece\_type" NUMBER(19,0), 
"rece\_dt" DATE, 
"state" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_DELIVER\_PACKAGE" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_customer" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"name" NVARCHAR2(50), 
"tel" NVARCHAR2(20), 
"mobile" NVARCHAR2(20), 
"email" NVARCHAR2(50), 
"type" NUMBER(10,0), 
"is\_own\_reg" NUMBER(10,0), 
"reg\_dt" DATE, 
"reg\_channel\_id" NUMBER(10,0), 
"state" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"last\_login\_dt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_CUSTOMER" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_codes" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"name" NVARCHAR2(50), 
"type" NUMBER(19,0), 
"code" NVARCHAR2(50), 
"code\_desc" NVARCHAR2(100), 
"code\_type" NVARCHAR2(50), 
"state" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
 CONSTRAINT "PK\_TBL\_CODES" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_warehouse" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"name" NVARCHAR2(50), 
"addr" NVARCHAR2(19), 
"addr\_gis" NVARCHAR2(50), 
"company\_id" NUMBER(19,0), 
"employee\_id" NUMBER(19,0), 
"type" NUMBER(10,0), 
"area" NVARCHAR2(50), 
"is\_lease" NUMBER(10,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_WAREHOUSE" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_consumer\_address\_map" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"consumer\_id" NUMBER(19,0), 
"address\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_CUSTOMER\_SENDER\_MAP" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_warehouse\_receipt" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"bill" NVARCHAR2(100), 
"type" NUMBER(19,0), 
"warehouse\_id" NUMBER(19,0), 
"operator\_id" NUMBER(19,0), 
"state" NUMBER(10,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_WAREHOUSE\_RECEIPT" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_warehouse\_send\_vehicle" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"out\_warehouse\_id" NUMBER(19,0), 
"out\_warehouse\_waybill\_id" NUMBER(19,0), 
"out\_warehouse\_waybill\_number" NVARCHAR2(100), 
"vehicle\_id" NUMBER(19,0), 
"driver1\_id" NUMBER(19,0), 
"driver2\_id" NUMBER(19,0), 
"start\_vehicle\_dt" DATE, 
"next\_warehouse\_id" NUMBER(19,0), 
"predict\_arrivals\_dt" DATE, 
"actual\_arrivals\_dt" DATE, 
"state" NUMBER(10,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_WAREHOUSE\_SEND\_VEHICLE" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_warehouse\_vehicle\_map" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"warehouse\_id" NUMBER(19,0), 
"vehicle\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_COMPANY\_VEHICLE\_MAP" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_dot" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"dot\_number" NVARCHAR2(50), 
"dot\_name" NVARCHAR2(50), 
"dot\_addr" NVARCHAR2(100), 
"dot\_gis\_addr" NVARCHAR2(100), 
"dot\_tel" NVARCHAR2(20), 
"company\_id" NUMBER(19,0), 
"manage\_area\_id" NUMBER(19,0), 
"manage\_area\_gis" NVARCHAR2(100), 
"state" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_DOT" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_transport\_tool" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"brand" NVARCHAR2(100), 
"model" NVARCHAR2(100), 
"type" NUMBER(19,0), 
"given\_load" NVARCHAR2(100), 
"load\_cn\_unit" NVARCHAR2(100), 
"load\_en\_unit" NVARCHAR2(100), 
"buy\_dt" DATE, 
"license\_plate" NVARCHAR2(100), 
"state" NVARCHAR2(100), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_TRANSPORT\_TOOL" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_dot\_transport\_tool" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"dot\_id" NUMBER(19,0), 
"transport\_tool\_id" NUMBER(19,0), 
"allocate\_dt" DATE, 
"state" NUMBER(10,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_DOT\_TRANSPORT\_TOOL" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_address" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"name" NVARCHAR2(50), 
"tel" NVARCHAR2(20), 
"mobile" NVARCHAR2(20), 
"detail\_addr" NVARCHAR2(100), 
"area\_id" NUMBER(19,0), 
"gis\_addr" NVARCHAR2(20), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_CUSTOMER\_ADDRESS" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_route" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"start\_station" NVARCHAR2(50), 
"start\_station\_area\_id" NUMBER(19,0), 
"start\_warehouse\_id" NUMBER(19,0), 
"end\_station" NVARCHAR2(50), 
"end\_station\_area\_id" NUMBER(19,0), 
"end\_warehouse\_id" NUMBER(19,0), 
"mileage\_m" NUMBER(10,0), 
"time\_consumer\_minute" NUMBER(10,0), 
"state" NUMBER(10,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_ROUTE" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_push\_warehouse" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"pw\_waybill\_id" NUMBER(19,0), 
"pw\_waybill\_number" NVARCHAR2(50), 
"pw\_dot\_id" NUMBER(19,0), 
"warehouse\_id" NUMBER(19,0), 
"emp\_id" NUMBER(19,0), 
"pw\_start\_dt" DATE, 
"pw\_end\_dt" DATE, 
"pw\_position" NVARCHAR2(50), 
"pw\_reg\_emp\_id" NUMBER(19,0), 
"ow\_reg\_emp\_scan\_gun\_id" NUMBER(19,0), 
"pw\_confirm\_emp\_id" NUMBER(19,0), 
"ow\_confirm\_emp\_scan\_gun\_id" NUMBER(19,0), 
"pw\_box\_emp\_id" NUMBER(19,0), 
"pw\_box\_scan\_gun\_id" NUMBER(19,0), 
"pw\_after\_seal\_img" NVARCHAR2(100), 
"pw\_receipt\_number" NVARCHAR2(100), 
"pw\_receipt\_dt" DATE, 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_PUSH\_WAREHOUSE" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_out\_warehouse" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"pw\_waybill\_id" NUMBER(19,0), 
"pw\_waybill\_number" NVARCHAR2(100), 
"ow\_dot\_id" NUMBER(19,0), 
"warehouse\_id" NUMBER(19,0), 
"ow\_vehicle\_id" NUMBER(19,0), 
"ow\_driver\_emp\_id" NUMBER(19,0), 
"ow\_follow1\_emp\_id" NUMBER(19,0), 
"ow\_follow2\_emp\_id" NUMBER(19,0), 
"ow\_start\_dt" DATE, 
"ow\_end\_dt" DATE, 
"ow\_position" NVARCHAR2(50), 
"ow\_reg\_emp\_id" NUMBER(19,0), 
"ow\_reg\_scan\_gun\_id" NUMBER(19,0), 
"ow\_confirm\_emp\_id" NUMBER(19,0), 
"ow\_confirm\_scan\_gun\_id" NUMBER(19,0), 
"ow\_pre\_seal\_img" NVARCHAR2(100), 
"ow\_receipt\_number" NVARCHAR2(100), 
"ow\_receipt\_dt" DATE, 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_OUT\_WAREHOUSE" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_warehouse\_emp" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"job\_num" NVARCHAR2(50), 
"name" NVARCHAR2(50), 
"birathday" DATE, 
"tel" NVARCHAR2(20), 
"type" NUMBER(10,0), 
"warehouse\_id" NUMBER(19,0), 
"state" NUMBER(10,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_WAREHOUSE\_EMP" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_express\_package" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"scan\_gun\_id" NVARCHAR2(19), 
"name" NVARCHAR2(50), 
"cid" NUMBER(10,2), 
"weight" NUMBER(10,2), 
"amount" NUMBER(10,2), 
"coupon\_id" NUMBER(19,0), 
"coupon\_amount" NUMBER(10,2), 
"actual\_amount" NUMBER(10,2), 
"insured\_price" NUMBER(10,2), 
"is\_fragile" NVARCHAR2(20), 
"send\_address\_id" NUMBER(19,0), 
"recv\_address\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_EXPRESS\_PACKAGE" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_express\_bill" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"express\_number" NVARCHAR2(50), 
"cid" NUMBER(19,0), 
"eid" NUMBER(19,0), 
"order\_channel\_id" NUMBER(19,0), 
"order\_dt" DATE, 
"order\_terminal\_type" NUMBER(10,0), 
"order\_terminal\_os\_type" NUMBER(10,0), 
"reserve\_dt" DATE, 
"is\_collect\_package\_timeout" NUMBER(10,0), 
"timeout\_dt" DATE, 
"type" NUMBER(10,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_EXPRESS\_BILL" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_consumer\_sender\_info" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"ciid" NUMBER(19,0), 
"pkg\_id" NUMBER(19,0), 
"express\_bill\_id" NUMBER(19,0), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_CUSTOMER\_SENDER\_INFO" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_collect\_package" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"cid" NUMBER(19,0), 
"eid" NUMBER(19,0), 
"pkg\_id" NUMBER(19,0), 
"express\_bill\_id" NUMBER(19,0), 
"express\_bill\_number" NVARCHAR2(100), 
"state" NUMBER(10,0), 
"collect\_package\_dt" DATE, 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_COLLECT\_PACKAGE" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS"; 

CREATE TABLE "tbl\_waybill" (
"id" NUMBER(19,0) NOT NULL ENABLE, 
"express\_bill\_number" NVARCHAR2(100), 
"waybill\_number" NVARCHAR2(100), 
"cid" NUMBER(19,0), 
"eid" NUMBER(19,0), 
"order\_channel\_id" NUMBER(19,0), 
"order\_dt" DATE, 
"order\_terminal\_type" NUMBER(10,0), 
"order\_terminal\_os\_type" NUMBER(10,0), 
"reserve\_dt" DATE, 
"is\_collect\_package\_timeout" NUMBER(10,0), 
"pkg\_id" NUMBER(19,0), 
"pkg\_number" NVARCHAR2(100), 
"timeout\_dt" NVARCHAR2(100), 
"transform\_type" NUMBER(10,0), 
"delivery\_customer\_name" NVARCHAR2(100), 
"delivery\_addr" NVARCHAR2(100), 
"delivery\_mobile" NVARCHAR2(100), 
"delivery\_tel" NVARCHAR2(100), 
"receive\_customer\_name" NVARCHAR2(100), 
"receive\_addr" NVARCHAR2(100), 
"receive\_mobile" NVARCHAR2(100), 
"receive\_tel" NVARCHAR2(100), 
"cdt" DATE, 
"udt" DATE, 
"remark" NVARCHAR2(100), 
 CONSTRAINT "PK\_TBL\_WAYBILL" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS";

-- 运输记录表
CREATE TABLE "tbl\_transport\_record" (  
   "id" NUMBER(19,0) NOT NULL ENABLE, 
   "pw\_id" NUMBER(19,0), 
   "pw\_waybill\_id" NUMBER(19,0), 
   "pw\_waybill\_number" NVARCHAR2(100), 
   "ow\_id" NUMBER(19,0), 
   "ow\_waybill\_id" NUMBER(19,0), 
   "ow\_waybill\_number" NVARCHAR2(100), 
   "sw\_id" NUMBER(19,0), 
   "ew\_id" NUMBER(19,0), 
   "transport\_tool\_id" NUMBER(19,0), 
   "pw\_driver1\_id" NUMBER(19,0), 
   "pw\_driver2\_id" NUMBER(19,0), 
   "pw\_driver3\_id" NUMBER(19,0), 
   "ow\_driver1\_id" NUMBER(19,0), 
   "ow\_driver2\_id" NUMBER(19,0), 
   "ow\_driver3\_id" NUMBER(19,0), 
   "route\_id" NUMBER(19,0), 
   "distance" NUMBER(10,0), 
   "duration" NUMBER(10,0), 
   "state" NUMBER(10,0), 
   "start\_vehicle\_dt" DATE, 
   "predict\_arrivals\_dt" DATE, 
   "actual\_arrivals\_dt" DATE, 
   "cdt" DATE, 
   "udt" DATE, 
   "remark" NVARCHAR2(100), 
    CONSTRAINT "PK\_TBL\_TRANSPORT\_RECORD" PRIMARY KEY ("id")
) TABLESPACE "TBS\_LOGISTICS";
8.2.2 配置管理器MGR进程
  • 进入源端OGG命令行
./ggsci
 #创建mgr进程：
 edit param mgr

PORT 7809
DYNAMICPORTLIST 7810-7909
AUTORESTART EXTRACT *,RETRIES 5,WAITMINUTES 3
PURGEOLDEXTRACTS ./dirdat/*,usecheckpoints, minkeepdays 3

在这里插入图片描述

8.2.3 配置extract进程

配置Extract进程：

edit param extkafka
# 新增内容：
extract extkafka

GETUPDATEBEFORES
NOCOMPRESSDELETES
NOCOMPRESSUPDATES
dynamicresolution
SETENV (ORACLE_SID = “orcl”)
SETENV (NLS_LANG = “american_america.AL32UTF8”)
userid erainm,password erainm
exttrail /u01/app/ogg/src/dirdat/to
table erainm.*;

在这里插入图片描述

img
img
img

既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，涵盖了95%以上Go语言开发知识点，真正体系化！

由于文件比较多，这里只是将部分目录截图出来，全套包含大厂面经、学习笔记、源码讲义、实战项目、大纲路线、讲解视频，并且后续会持续更新

如果你需要这些资料，可以戳这里获取

19,0),
“ow_driver1_id” NUMBER(19,0),
“ow_driver2_id” NUMBER(19,0),
“ow_driver3_id” NUMBER(19,0),
“route_id” NUMBER(19,0),
“distance” NUMBER(10,0),
“duration” NUMBER(10,0),
“state” NUMBER(10,0),
“start_vehicle_dt” DATE,
“predict_arrivals_dt” DATE,
“actual_arrivals_dt” DATE,
“cdt” DATE,
“udt” DATE,
“remark” NVARCHAR2(100),
CONSTRAINT “PK_TBL_TRANSPORT_RECORD” PRIMARY KEY (“id”)
) TABLESPACE “TBS_LOGISTICS”;


#### 8.2.2 配置管理器MGR进程


* 进入源端OGG命令行

./ggsci
#创建mgr进程：
edit param mgr



> 
> PORT 7809  
>  DYNAMICPORTLIST 7810-7909  
>  AUTORESTART EXTRACT \*,RETRIES 5,WAITMINUTES 3  
>  PURGEOLDEXTRACTS ./dirdat/\*,usecheckpoints, minkeepdays 3
> 
> 
> 


![在这里插入图片描述](https://img-blog.csdnimg.cn/20201030103722817.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2VyYWluaW5n,size_16,color_FFFFFF,t_70#pic_center)


#### 8.2.3 配置extract进程


配置Extract进程：

edit param extkafka

新增内容：

extract extkafka



> 
> GETUPDATEBEFORES  
>  NOCOMPRESSDELETES  
>  NOCOMPRESSUPDATES  
>  dynamicresolution  
>  SETENV (ORACLE\_SID = “orcl”)  
>  SETENV (NLS\_LANG = “american\_america.AL32UTF8”)  
>  userid erainm,password erainm  
>  exttrail /u01/app/ogg/src/dirdat/to  
>  table erainm.\*;
> 
> 
> 


![在这里插入图片描述](https://img-blog.csdnimg.cn/20201030103856655.png#pic_center)



[外链图片转存中...(img-fY3wDIf1-1715403582151)]
[外链图片转存中...(img-MqbzIHhF-1715403582152)]
[外链图片转存中...(img-7cGwEEOR-1715403582152)]

**既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，涵盖了95%以上Go语言开发知识点，真正体系化！**

**由于文件比较多，这里只是将部分目录截图出来，全套包含大厂面经、学习笔记、源码讲义、实战项目、大纲路线、讲解视频，并且后续会持续更新**

**[如果你需要这些资料，可以戳这里获取](https://bbs.csdn.net/topics/618658159)**
2401_84931473
关注
  • 20
    点赞
  • 踩
  • 19
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
常问的OGG问题
u011868279的博客
03-21 1994
常问的OGG问题
Oracle GoldenGate（OGG）- 超级详细
热门推荐
erainm
10-30 3万+
1. OGG简介 2. 应用场景 3. 基本原理 4. 基本架构 5. 常用的拓扑结构 6. 支持的环境 7. OGG安装部署 7.1 配置Oracle11gR2数据库 7.2 安装OGG源端 7.3 配置OGG源端 7.4 配置OGG目标端 7.5 OGG测试 8. 初始化业务数据 8.1 安装OGG源端 8.2 配置OGG源端 8.3 配置OGG目标端 8.4 OGG测试
物流项目中Oracle 数据库的使用及OGG是如何同步_oracle ogg数据同步
2401_84182097的博客
05-04 1078
​ Oracle GoldenGate 实现原理是通过抽取源端的redo log 或者 archive log ，然后通过TCP/IP投递到目标端，最后解析还原应用到目标端，使目标端实现 同源端数据同步。Extract提取Pump进程Collect进程Replicat进程OGG采集数据时，完整结构如上如所示：分为源端SRC和目标端DST，都有自己管理进程MGR。​Data pump。
oracle ogg是什么
qq_183574716的博客
08-04 1万+
GoldenGate（简称OGG）提供异构环境下交易数据的实时捕捉、变换、投递。 1、OGG原理 OGG是一种基于日志的结构化复制软件，通过捕捉源数据库online redo log(在线重做日志)或archive log(归档日志)获得数据变化，形成tail(队列文件)，再把这些tail文件通过网络协议传输到目标数据库，目标端通过解析，插入至目标端数据库，从而实现源端与目标端的数据同步。 2、OGG特性 1）、对生产系统影响小：实时读取交易日志，以低资源占用实现大...
Oracle OGG
u013244668的博客
09-08 895
参考博客：http://www.cnblogs.com/qiumingcheng/p/5435907.html Oracle Golden Gate（OGG）软件是一种基于日志的结构化数据复制备份软件。大数据实时复制（实时同步）。 提供异构环境下交易数据的实时捕捉、变换投递。 它通过解析源数据库在线日志或归档日志获得数据的增量变化，再将这些变化应用到目标数据库，从而实现源数据与目标数
Oracle GoldenGate（OGG）基础知识整理
Ruishine的博客
07-01 9685
一、GoldenGate简介 GoldenGate软件是一种基于日志的结构化数据复制软件。它通过解析源数据库在线日志或归档日志获得数据的增删改变化（数据量只有日志的四分之一左右），能够实现大量交易数据的实时捕捉、变换和投递，实现源数据库与目标数据库的数据同步，保持最少10ms的数据延迟。 Oracle Golden Gate可以在异构的IT基础结构（包括几乎所有常用操作系统平台和数据库平台）之间实现大量数据亚秒级的实时复制,从而在可以在应急系统、在线报表、 实时数据仓库供应、交易跟踪、数据同步、集中/分发、
OGG搭建详细步骤（Oracle GoldenGate）
03-01
本文将详细介绍如何在2021年6月的环境中搭建一套单机单的OGG环境，适用于Oracle 11.2.0.4版本的数据库。 **1. OGG 环境准备** 在开始OGG的搭建前，需要确保硬件环境满足要求。对于源端和目标端，都应具备以下配置...
Oracle GoldenGate 12.2.0.2.2 for Oracle on Linux x86-64.zip
04-25
在Oracle GoldenGate 12.2.0.2.2版本中，它为Linux x86-64架构提供了全面的支持，确保在64位Linux环境中高效运行。 **Oracle GoldenGate的主要组件和功能：** 1. **Extract（抽取）**：这是GoldenGate的数据源端...
Oracle GoldenGate V11.1.1.1.2 for Oracle 11g on Linux x86-64.zip
04-25
首先，OGG_WinUnix_Rel_Notes_11.1.1.1.2.pdf文档很可能是Oracle GoldenGate在Windows和Unix平台上的发行说明，其中详细介绍了此版本的新特性、增强功能、已知问题以及解决方法。在阅读这份文档时，用户可以了解如何...
Oracle GoldenGate19.1.0.0.4 for Linux-x64 安装包
最新发布
06-21
首先，"OGG_WinUnix_Rel_Notes_19.1.0.0.4.pdf" 文件是Oracle GoldenGate 19.1.0.0.4的Windows和Unix平台发布说明，其中包含了该版本的重要更新、新特性、性能改进以及已知问题和解决策略。在安装和配置过程中，这份...
Oracle GoldenGate 11.2.1.0.3 for Oracle 11g on Linux x86-64 - V34339-01.zip
06-20
Oracle GoldenGate是一款强大的数据复制和实时数据集成工具，主要用于实现数据库间的实时数据同步。这个版本，11.2.1.0.3，是专为Oracle 11g数据库在Linux x86-64架构上的环境设计的。在E36358-01的发布说明中，通常...
OGG(oracle golden date)详细部署 Oracle 11g
08-13
OGG(oracle golden date)详细部署 for Oracle 11g OGG(oracle golden date)详细部署 for Oracle 11g
牛逼的OGG oracle golden date 详细部署 Oracle 11g
03-03
本文档是作者学习Goldendate时的相关实验过程 1 环境介绍 2 实验步骤 1 创建ogg操作系统用户 2 修改OGG操作系统用户环境变量 3 创建OGG安装目录 4 上传OGG安装介质 3 验证OGG复制
Oracle高可用解决方案：RAC、DG和OGG简介
renkejia1988的博客
09-01 4095
根据具体情况选择合适的解决方案，可以提高数据库的可用性和数据保护能力。
OGG(Oracle GoldenGate)的安装和单向同步
weixin_52444902的博客
06-29 3290
OGG安装和单向同步
物流项目中Oracle 数据库的使用及OGG是如何同步_oracle ogg数据同步(1)
2401_84185074的博客
05-01 653
(img-raxWXsjJ-1714524608522)](img-xYppoULm-1714524608523)](img-Weyg9ADF-1714524608523)]“company_name”: “广州码农速递邮箱公司”,“company_name”: “广州码农速递邮箱公司”,– 插入数据INSERT。
Oracle GoldenGate（OGG）讲解
weixin_54342458的博客
09-06 2563
数据分发服务器DDS在讨论ogg之前，这里我想介绍一下，之前我了解的数据分发服务DDS，DDS采用发布 / 订阅体系架构，强调以数据为中心，提供丰富的 QoS 服务质量策略，能保障数据进行实时、高效、灵活地分发，可满足各种分布式实时通信应用需求。DDS信息分发中间件是一种轻便的、能够提供实时信息传送的中间件技术。Oracle GoldenGate 简称ogg，是用于实时数据集成和复制的综合软件包。它支持高可用性解决方案，实时数据集成，事务性更改数据捕获，数据。
使用数据泵+ogg同步oracle数据
雅冰石的专栏
06-21 2235
在同步开始前目标端没有初始化数据(目标端为空数据)，那么事物产生的UPDATE、DELETE DML操作发送到目标端，目标端GoldenGate Replicat进程会因为找不到数据而报错从而导致Replicat进程崩溃停止(ABENDED)，所以这就需要我们在同步前初始化数据，初始化完后再同步，这样大大降低错误率。原本想用RMAN方式迁移，但是由于旧库是AIX系统，新库是linux系统，用RMAN迁移会有问题，于是考虑用数据泵+ogg的方式实现不停机迁移。返回值yes为打开，pk，ui都需要打开。
oracle ogg搭建实战
weixin_52805903的博客
03-28 258
【代码】oracle ogg搭建实战。
Oracle Goldengate TDM监控运维指南：中文实战解析
在部署和维护过程中，开发、测试和运维团队的紧密协作至关重要，因为软件可能存在特定限制，需要提前了解并避免在生产环境中遇到问题。 2. 基于命令行的监控： - 通过命令行界面，用户可以监控金环（GG）进程的...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值