OraFAQ Forum: Client Tools » Help me to find the best tool

Home » Other » Client Tools » Help me to find the best tool

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help me to find the best tool [message #428502]

Wed, 28 October 2009 09:34

whatisDB
Messages: 2
Registered: October 2009

Junior Member

hello,

I am trying to find a best Tool available in the market that will satisfy the following requirements:

The condensed requirements are as follows:

--> We have a database, lets call it "R2-D2".
--> We have 3 tables that are updated everyday with new information. Lets call all these 3 tables as secondary storage tables.
--> We have another 4 tables which we are going to call "primary tables".
--> The secondary storage tables and primary storage tables have 16 columns in each that have to be compared with each other. In other words 16 columns from 3 tables of secondary storage table have to be compared with 16 columns of the 4 primary storage tables.

Question:
1. Is there a tool to compare data between these tables using a form or a GUI? something that an end user can access to view the information in a comparison form?
2. Once the comparison is done can we either UPDATE or INSERT data from the secondary storage tables to the primary storage tables?

Any help in this regard is greatly appreciated.

Report message to a moderator

Re: Help me to find the best tool [message #428503 is a reply to message #428502]

Wed, 28 October 2009 09:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

FIREFOX & a small matter of programming

Report message to a moderator

Re: Help me to find the best tool [message #428506 is a reply to message #428503]

Wed, 28 October 2009 09:45

whatisDB
Messages: 2
Registered: October 2009

Junior Member

The problem is we dont have a programmer and our budget is less than $500.

Report message to a moderator

Re: Help me to find the best tool [message #428998 is a reply to message #428502]

Sat, 31 October 2009 20:29

Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec

Senior Member

Hi,

I know that PLSQL Developer have a functionnality to "Compare Table Data". So if your table have the same structure you can use it to do the compare. It can also generate the INSERT,UPDATE, and DELETE if required.

Hope it help.

Report message to a moderator

Re: Help me to find the best tool [message #430498 is a reply to message #428998]

Tue, 10 November 2009 13:30

wvu1999
Messages: 40
Registered: April 2007

Member

Toad for Data Analysts does this very nicely, supports multiple tables from multiple instances, even if on different servers and no need for DB_LINKs. Can also work on tables with different structures.

And it supports XLS, Access, SQL Server, etc in addition to Oracle.

Fits in your budget as well.

Report message to a moderator

Re: Help me to find the best tool [message #430500 is a reply to message #430498]

Tue, 10 November 2009 13:40

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

TOAD does many behind the scene and you don't know what.
TOAD locks resources without you know it and may lead to ORA-1555 or "unable to extend" errors in other sessions without speaking those that are blocked because of it.
...

Regards
Michel

[Updated on: Tue, 10 November 2009 13:41]

Report message to a moderator

Re: Help me to find the best tool [message #430503 is a reply to message #430500]

Tue, 10 November 2009 14:03

wvu1999
Messages: 40
Registered: April 2007

Member

If you ask to change something, Oracle's going to lock the object appropriately. No differently than issuing an UPDATE via SQL*Plus.

If you don't understand transactions in oracle, you can always make Toad 'Read Only'.

Report message to a moderator

Re: Help me to find the best tool [message #430559 is a reply to message #430503]

Wed, 11 November 2009 01:05

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The point is not understanding or not transaction, it is the fact that TOAD do some things behind the scene WITHOUT telling what it does and LOCKS some resource without you know it because you don't know what it does.

If you use SQL*Plus, you know what it does because SQL*Plus does not do anything you don't tell it to do.

Regards
Michel

Report message to a moderator

Re: Help me to find the best tool [message #430600 is a reply to message #430559]

Wed, 11 November 2009 02:57

Frank
Messages: 7901
Registered: March 2000

Senior Member

Michel Cadot wrote on Wed, 11 November 2009 08:05

If you use SQL*Plus, you know what it does because SQL*Plus does not do anything you don't tell it to do.

I think it is about time to face reality here. People want to and will use graphical tools to do database access.
You can not and should not expect everyone to use sqlplus.

Having said that, tools should clearly document what behaviour is to be expected (in your case, when it will lock what)

Report message to a moderator

Re: Help me to find the best tool [message #430640 is a reply to message #430600]

Wed, 11 November 2009 06:11

wvu1999
Messages: 40
Registered: April 2007

Member

If you click in a 'live' data grid, i.e. one that is setup for editing, Toad can place a row-level lock.

You can avoid this several ways. Best is to use option to default to Read Only data grids.

You can always see what Toad is doing with the Database > Spool SQL to Screen option.

Somehow we got off topic, my original answer was to look at Toad for Data Analysts, which has a completely different transaction architecture than Toad for Oracle and comments around the 'mystery locks' do NOT apply.

Report message to a moderator

Previous Topic:	TOAD 8.6 on Windows 7
Next Topic:	isqlplus not starting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 22:56:05 CDT 2025