Partitioning using dbms_redefinition and supplemental log data

Hi to all,

i´m a newbie in Oracle. Sorry for my ignorance.

We are running a 10.2.0.5 Oracle database in HP-UX 11.31, replicated via streams with other database.

We must partition some table, for example we must partition table 'DATOS'. The creation table DDL is:

CREATE TABLE "DATOS"

   ( "ID_DISPENSACION" NUMBER(12,0) CONSTRAINT "CK_DATOS_01" NOT NULL ENABLE,

     "FECHAFINACTIVACION" DATE,

     "FECHAMODIFICACION" DATE NOT NULL ENABLE,

               .....

               .....

      CONSTRAINT "PK_DATOS" PRIMARY KEY ("ID_DISPENSACION") 

TABLESPACE "DATOSE00" ,

  SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,

  SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS,

  SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS,

);

There are some supplemental logs as seen above...

We´ll use "DBMS_REDEFINITION" package to do the partitioning by range on "ID_DISPENSACION":