Re: 8i-10g upgrade

From: Joerg Jost <>
Date: Fri, 28 Nov 2008 14:35:15 +0100
Message-Id: <1227879315.3883.19.camel@localhost>

Hi there,

i do things like this very often because of my job. But i did not do this with databases so large. So please read my suggestions with this in mind :)

But my suggestion is, do this Tablespace for Tablespace. If i got you, you have more than 2 or 3 of them. So do the datapump for one after the other. This will result in some possible positive sideeffects.

You do not need the space of the hole database twice. You do not need so much downtime per Tablespace. You will have (probably) parts of the application online. (Depends on the architecture of SAP).

In front of each import you can drop the old Tablespace to save the space.

Maybe this is a way to solve this "timing" problem?


Jörg Jost
OCP 10gR2

Received on Fri Nov 28 2008 - 07:35:15 CST

Original text of this message