Re: 8i-10g upgrade
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: guillermo.bort@xxxxxxx
- Date: Sun, 30 Nov 2008 08:11:14 -0800
On Fri, Nov 28, 2008 at 5:19 AM, Bort, Guillermo <guillermo.bort@xxxxxxx>wrote:
> We thought about DBMS_REDEFINITION (or the legacy alter table move),
> however that would imply creating new tablespaces, and since the rdbms
> server a SAP aplication, creating new tablespaces is a bit of a headache,
> and moving objects arround is even worse. So basically we need to have the
> same structure on another server, move the tbs to locally and still have the
> db synchronized.
>
>
DBMS_REDEF requires converting all LONGS to LOBS, which DBMS_REDEF will do,
but
that may not be what you want to do. There are some SAP notes on this.
ALTER TABLE MOVE will not work with LONG/LONG RAW columns, and as you are a
aware, there
are a few in SAP systems.
Jared
Other related posts:
