Re: Oracle GUI admin tool?

David E. Grove wrote:

> Folks,
>
> Our shop is about to adopt Oracle for a new project. We would be coming
> from an Informix environment. I will be the DBA, and have just started down
> the path of learning the Oracle world.
>
> Does Oracle have, either natively, or from a third party, a GUI sysadmin
> tool. If anyone here is familiar with the Informix world, I have in mind
> something comparable to "Server Studio".
>
> Thank you.
>
> DG

This may help a bit:
http://www.psoug.org/reference/informix.html

It is hardly complete but is part of my note-taking process.

I would urge you to purchase a copy of Tom Kyte's book "Expert one-on-one Oracle". Be sure to read the first three chapters with great care. Every time Tom writes about SQL Server ... think Informix.

You will find there are huge differences in the underlying architecture. The surface stuff will be things like how triggers are written, sequences, etc. But the multiversioning, the security model, and the fact that reads don't block writes and writes don't block reads are things you need to really understand.

Best wishes ... and if you would like to referral to someone who has been down the same path and is an expert in both environments ... contact me off-line and I will pass along the name and contact info.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)