Re: Why SAP, PeopleSoft, Siebels Move from Oracle to DB2 ?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 8 Jan 2002 15:01:46 -0000
Message-ID: <3c3b09e3$0$234$ed9e5944@reading.news.pipex.net>

"Peter Lintner" <peter.lintner_at_sos-kd.org> wrote in message news:HFD_7.8$af.641_at_psinet-eu-nl...
> Hi!
> Moving from Oracle to DB2 make sense if you have the know how on
> administrate DB2 and it depends on the amount of data.
> Reorganization of an Oracle-DB would be impossible, if it grows over about
> 150 to 200 GB.
> The SAP-System would be offline for some days.
> Online-.Reorganization with DB2 is no problem.

What do you mean by reorganizing?

If you mean moving tables around from one tablespace to another this can be done online.
If you mean exporting recreating and importing to eliminate fragmentation then you have badly screwed up in your database creation. you should NEVER have to do this anymore.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Tue Jan 08 2002 - 09:01:46 CST