SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DB Difference Expert

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DB Difference Expert
Author Message
John Wilson



Joined: 30 Jan 2003
Posts: 1

Post DB Difference Expert Reply with quote

With regards to your DB Difference Expert trial version, is the creator of the repository the required user to do the data comparisons? Does a database link have toexist between the two databases to allow database to database comparison of a table that exists in the same schema? When trying to do a comparison between data in tables in the same schema from two different databases, the tool returns no differences even though differences truly exist between the tables. Thank you in advance for your support.

Thu Jan 30, 2003 11:01 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Re: DB Difference Expert Reply with quote

The repository can be created by any user with admin privileges. If you want other non-admin users to be able to access the repository and run DB Difference simply grant them SELECT/INSERT/DELET/UPDATE privileges on tables in ORA_MONITOR schema. If you wish you can also grant these permissions to PUBLIC.

In order to compare data in two different databases you must have a valid database link that would allow DB Difference to work with both tables as if they were both "local" tables.

If you do not select the correct link or the link is invalid or points to the same database or you have insufficient permissions to use the link or access data in the "remote" database (the one accessed through the link) you may get an empty result because the comparison query will fail and return no data.

Normally you should get an error message if something goes wrong.

: With regards to your DB Difference Expert trial version, is the creator of
: the repository the required user to do the data comparisons? Does a
: database link have toexist between the two databases to allow database to
: database comparison of a table that exists in the same schema? When trying
: to do a comparison between data in tables in the same schema from two
: different databases, the tool returns no differences even though
: differences truly exist between the tables. Thank you in advance for your
: support.

Thu Jan 30, 2003 11:37 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.