oracle ic4 收入,DBDiff for Oracle

DBDiff for Oracle 是用来比较两个Oracle schema异同的一个小工具。可以比较权限，表结构，视图结构，索引，约束，序列，表数据，视图数据，触发器，包，包体，函数，过程，类型，类型体等等。

具体功能看官方介绍：

另外，OraFAQ对这个工具也有介绍：

官方网站上可以下到demo版()

比较时的主要界面：

比较的结果如下：

< DATABASE 1:NING@NING

> DATABASE 2:

Differences found in system privileges

PRIVILEGEADMIN OPTION_

Differences found in role privileges

GRANTED ROLEADMIN OPTIONDEFAULT ROLEOS GRANTED_

>CONNECTNOYESNO

Differences found in object privileges

PRIVILEGETABLE NAMEOWNERGRANTEEGRANTORGRANTABLE_

26tables were found inNING@NING

0tables were found in

The following tables DO NOT exist in

BIN$e1qUSe8vQQiU9lFFYnMJ7w==$0

BIN$8bLjznPlRoioTrMiKI/YUg==$0

BIN$gBo6cUZnTMKady7Prxmr3A==$0

BIN$5laeMO9NSdK2mvDDF/QM6w==$0

BIN$2emTg5hhR8iAWHwHO9yJHA==$0

The following tables were not processed in

NOTE: The Demo version will only process the first 5 tables in alphabetical order,

if more than 5 tables exist in your database, they will appear in this section.

COLS255

COLS254

COLS256

COLS511

COLS260

COLS257

TESTDIM

ITL

TMP

BIN$Q3KgLnUgStGMfbZILCY0Gw==$0

BIN$RPq3nKBoS96SY/u1Ff6bow==$0

BIN$H7FDdRrBS0uw7kc6DWU6WQ==$0

BIN$PFZrpEZCQ2iC4VMsQPVhCg==$0

BIN$SG7Qv49SR/a8mkoCWAYuWg==$0

BIN$V9drUKNiQQOGslcIFFjntg==$0

T2

BIN$iJermRGLTXiy2YfNbqJVxg==$0

T1

BIN$W5dSTLm3Q4iKDDg5e/gVUw==$0

BIN$s2Mmqz2PQw+BGYMknTZBwQ==$0

TEST

0views were found inNING@NING

0views were found in

2triggers were found inNING@NING

0triggers were found in

The following triggers DO NOT exist in

BIN$ZzTBPKmbRgKmRYkbCAoFJQ==$0

TR_T1

0views were found inNING@NING

0views were found in

0functions were found inNING@NING

0functions were found in

0packages were found inNING@NING

0packages were found in

0packages body were found inNING@NING

0packages body were found in

2stored procedures were found inNING@NING

0stored procedures were found in

The following stored procedures DO NOT exist in

TEST_CASE

TEST_COLS

0types were found inNING@NING

0types were found in

0types body were found inNING@NING

0types body were found in

--- End of DBDiff for Oracle --- Elapsed Time: 00:00:01 ---