ITPub博客

首页 > Linux操作系统 > Linux操作系统 > DBDiff for Oracle

DBDiff for Oracle

原创 Linux操作系统 作者:NinGoo 时间:2019-06-02 13:54:05 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2004-12-07

  • 博文量
    200
  • 访问量
    129120