Re: Oracle/Informix admin.

Posted in 2000

Obnoxio The Clown — Thu, 12 Oct 2000 10:26:08 BST — source: Informix-list mailing list archive (1991-1998)

From: John Harman <harmanj@agric.nsw.gov.au> > > Need some info from people who have driven both Oracle and >Informix as administrators. > What are the main differences from this point of view? > Could someone easily move between them? Especially from Informix > to Oracle? The other way round is much easier. Informix has a coherence of design and use that is largely missing from Oracle. Although the fundamental principles of operation are surprisingly similar, the implementations are very different. I personally find Oracle a huge pain in the ass to use. There are no nifty tools to monitor it, so you have to buy BMC or something to do all the clever stuff for you. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

↪ replying to Obnoxio The Clown

Rudy Fernandes — Thu, 12 Oct 2000 09:04:28 -0400 — source: Informix-list mailing list archive (1991-1998)

Obnoxio The Clown wrote: > From: John Harman <harmanj@agric.nsw.gov.au> > > > > Need some info from people who have driven both Oracle and > >Informix as administrators. > > What are the main differences from this point of view? > > Could someone easily move between them? Especially from Informix > > to Oracle? > > The other way round is much easier. Informix has a coherence of design and > use that is largely missing from Oracle. Although the fundamental principles > of operation are surprisingly similar, the implementations are very > different. I personally find Oracle a huge pain in the ass to use. There are > no nifty tools to monitor it, so you have to buy BMC or something to do all > the clever stuff for you. Seconded (surprisingly :)) in its entirety. Rudy

↪ replying to Obnoxio The Clown

cdlvj — Thu, 12 Oct 2000 13:47:36 -0500 — source: Informix-list mailing list archive (1991-1998)

I agree, Informix is much simpler. One of the nice features which goes back many versions is the Unload statement with Select. Just plain text which Oracle and MSSQL don't implement nicely. "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:8s416u$d4q$1@news.xmission.com... > > From: John Harman <harmanj@agric.nsw.gov.au> > > > > Need some info from people who have driven both Oracle and > >Informix as administrators. > > What are the main differences from this point of view? > > Could someone easily move between them? Especially from Informix > > to Oracle? > > The other way round is much easier. Informix has a coherence of design and > use that is largely missing from Oracle. Although the fundamental principles > of operation are surprisingly similar, the implementations are very > different. I personally find Oracle a huge pain in the ass to use. There are > no nifty tools to monitor it, so you have to buy BMC or something to do all > the clever stuff for you. > > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com. > >