oracle基于dblink创建视图,【案例】Oracle dblink 数据库连接dblink insert操作数据类型发生改变...

天萃荷净

开发DBA反映Oracle数据库两库之间通过dblink相连。在使用DML语句insert插入数据时操作的数据类型发生了改变

1.Oracle insert列属性

[oracle@saas-xunzhi-db1 ~]$ sqlplus testga/testga

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 12 16:26:56 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> desc t_oracleplus;

Name Null? Type

----------------------------------------- -------- ----------------------------

PROCESS_INSTANCE_ID NOT NULL NUMBER(10)

STATUS_NEW NUMBER

PACKAGE_NAME VARCHAR2(50)

SQL> desc wf_proc_inst@oldmoa

Name Null? Type

----------------------------------------- -------- ----------------------------

ID NOT NULL NUMBER(10)

NAME VARCHAR2(500)