RE: Informix Online Reorg.

I think he meant move tables around, defragment them ... with users online. I am not sure though. You can not move a table with users online. Their are ways you can minimize the downtime, but not eliminate it. Not being an Oracle admin I dont know if Oracle can do this. Will >===== Original Message From "Obnoxio The Clown" <obnoxio@hotmail.com> ===== >From: "xaw" <xaw_spam_@mail.com> >> >>Hello dear DBAs. > >Errm.... > >>I heard that it is not possible to make online reorganizations on Informix. > >You probably heard this from the same person who said you can do it in >Oracle, right? > >>I'm sorry if this is unclear... I mean a way to have maintenance jobs run >>while >>the database keeps on running. As far as I know, it is possible to do with >>Oracle >>DBs. >>Well, I just want double check. Some comments ? > >Yes. Most of them unprintable. I can't think of a single reorg operation >that wouldn't require the database to be online. In other words, the >database must be running to do most reorgs. IIRC, adding logical logs >requires quiescent, and moving the physical log takes the server down, but I >bet you couldn't do either of those (or rather, their equivalents) in Oracle >without a recycle either. > >What, specifically, do you want to do? >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------