Re: Good Windows based DBA tools for Oracle 7.3

> I require a tool that will help me with:
> 1. day-to-day tasks - like creating tables and indexes, managing
> users, etc

For this I would strongly recommend that you get a CASE tool such as Designer/2000 or Erwin ERX. These tools will not only create tables, indices, foreign keys, and domains, they will simultaneously document your system and allow you some degree of version control.

> 3. more complicated tasks - like moving or restructuring a table that
> has production data in it and has many triggers, constraints and other
> dependencies

There are more expensive tools that may do all of these things but be sure to look at the capabilities in Eventus' SQL Studio. For $495 is does 90% of what you want.

> 4. performance tuning - I understand that some tools even have
> 'wizards' that will make recommendations for improving performance

Also discuss this with Eventus. Some of their other products like Ad Hoc Monitor may solve your problems.

> Ideally I am looking for a product that I can download from the 'net
> and evaluate for a period before I buy.

I think this will prove to be wishful thinking.

Daniel A. Morgan Received on Fri Apr 04 1997 - 00:00:00 CST