DBDiff for Oracle

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

具体功能看官方介绍：http://www.dkgas.com/oradbdiff.htm

另外，OraFAQ对这个工具也有介绍：http://orafaq.com/tools/dkg/dbdiff.htm

官方网站上可以下到demo版（http://www.dkgas.com/oradbdiff.exe）

比较时的主要界面：

比较的结果如下：

< DATABASE 1: NING@NING

> DATABASE 2: TEST@NING

Differences found in system privileges

PRIVILEGE ADMIN OPTION _

< CREATE TABLE NO

< UNLIMITED TABLESPACE NO

Differences found in role privileges

GRANTED ROLE ADMIN OPTION DEFAULT ROLE OS GRANTED _

> CONNECT NO YES NO

< DBA NO YES NO

Differences found in object privileges

PRIVILEGE TABLE NAME OWNER GRANTEE GRANTOR GRANTABLE _

< READ DIR_TEST SYS NING SYS YES

< WRITE DIR_TEST SYS NING SYS YES

26 tables were found in NING@NING

0 tables were found in TEST@NING

The following tables DO NOT exist in TEST@NING

BIN$e1qUSe8vQQiU9lFFYnMJ7w==$0

BIN$8bLjznPlRoioTrMiKI/YUg==$0

BIN$gBo6cUZnTMKady7Prxmr3A==$0

BIN$5laeMO9NSdK2mvDDF/QM6w==$0

BIN$2emTg5hhR8iAWHwHO9yJHA==$0

The following tables were not processed in NING@NING

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

0 views were found in NING@NING

0 views were found in TEST@NING

2 triggers were found in NING@NING

0 triggers were found in TEST@NING

The following triggers DO NOT exist in TEST@NING

BIN$ZzTBPKmbRgKmRYkbCAoFJQ==$0

TR_T1

0 views were found in NING@NING

0 views were found in TEST@NING

0 functions were found in NING@NING

0 functions were found in TEST@NING

0 packages were found in NING@NING

0 packages were found in TEST@NING

0 packages body were found in NING@NING

0 packages body were found in TEST@NING

2 stored procedures were found in NING@NING

0 stored procedures were found in TEST@NING

The following stored procedures DO NOT exist in TEST@NING

TEST_CASE

TEST_COLS

0 types were found in NING@NING

0 types were found in TEST@NING

0 types body were found in NING@NING

0 types body were found in TEST@NING

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/193161/viewspace-50304/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/193161/viewspace-50304/