Re: Informix vs. Oracle Question

I am going through this process right now. Informix (IMHO) is much easier to manage and set up. Backup and recovery in v7 is adequate at best but is much better in v8. Where most (if not all Informix sites) use raw disc most Oracle sites use cooked file systems. If you have a choice go to Oracle8 as soon as possible. More 3rd party tools exist for Oracle but given it is more complicated to manage they are absolutely required in large installations. The redo and archive log process is ugly and a real headache. A very nice feature in 7.3.3 is the index rebuild which allows for inplace index rebuilds using data in the existing index - real cool. Well, those are just a few things off the top of my head. Be prepared to spend money on 3rd party tools to do what you dont need them for today in Informix. Good luck ! ttpayne@tuc.com wrote: > > I'm an Informix DBA, and it looks as though my employer will > be bringing Oracle in-house for one of our non mission-critical > applications. > > My question: Is there anyone out there who has administered > both Informix and Oracle databases? If so, what can you contrast > the two and give me your opinion ( I.E., pros and cons of each)? > > Please e-mail responses to ttpayne@tuc.com. > > Thanks in advance! > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/ Now offering spam-free web-based newsreading -- Tony Johnson Email : rp2360@email.sps.mot.com Senior Database Administrator Voice : ( 602 ) 655 - 4617 Motorola SPS / Western Region CIM Pager : ( 602 ) 409 - 4481 2200 W. Broadway Rd. MD M555 Fax : ( 602 ) 655 - 3569 Mesa, AZ 85202 -------------------------------------------------------------------------------- We Are One. One Team. One Voice. One Objective : To Be No. 1 With Our Customers. No RAS. DWYSYWD. LOPOYPDNNMAEOMP. Top Box. WDIRTFTWYCDIA.