Re: SYBASE DBA TO ORACLE DBA

Leng Kaing (leng_at_comsense.com) wrote:
: Casey Claiborne wrote:
: >
: > Hello,
: > I currently have been trained in performance tuning for
: > SYBASE system 11; however, I am wondering
: > if there are significant or small differences between the
: > administration of an Oracle database vs. a SYBASE database - i.e.
: > how hard is it to switch from SYBASE administration to Oracle
: > administration? Are the structures for SYBASE similar to
: > Oracle - i.e. using b-tree for indexes, the creation of several
: > databases - (tempdb, master, etc. for SYBASE) when the
: > product is installed, etc.
: >
: > I would be *truly* grateful for any information
: > on the subject :)
: >
: > TIA
 
: I went the other way around approx. 18 months ago. Not a very smooth
: experience to say the least. Knowing Oracle didn't help me at all. I had
: to enrol into a Sybase Admin class to come to grips with it all. Sybase
: and Oracle are 2 completely different rdbms'. They may even use the same
: terminology and mean completely different things. So, no you cannot
: apply your sybase knowledge to Oracle. It's best to start from scratch
: with Oracle.
 

: HTH,
: Leng.

I agree that knowledge of another animal hurts more than it helps. I went from informix DBA to Oracle DBA 2 years ago. Although informix and Oracle are considered similar in architecture, crossing the boundary brings lots of confusions. It's best to completely forget your previous knowledge at the begining, then, maybe at later time when you are more comfortable with the new one, compare the knowledge back, you may find yourself suddenly know more on both sides.

So I'd say it hurts first but in the long run, it helps.

But after 2 years, I still think Informix is a better engine. Sorry, can't help it.

-Bass Chorng Received on Wed Mar 05 1997 - 00:00:00 CST