replicating a nested table
edited May 30, 2011 3:55AM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered
Hi,
I'm trying to implement schema replication in a 11.2.0.2 database with Oracle Streams. In my schema there is a a table containing a nested table defined as follow:
CREATE OR REPLACE TYPE COMPTEUR_T AS OBJECT
(
INDICE NUMBER(3),
COMPTEUR NUMBER(10)
)
/
CREATE OR REPLACE TYPE COMPTEURTBL_T AS TABLE OF COMPTEUR_T
/
CREATE TABLE T_STATFLUX
(
other columns,
STATFLUX_COMPTEURS COMPTEURTBL_T
)
NESTED TABLE STATFLUX_COMPTEURS STORE AS COMPTEURTBL_T_TBL
I know Oracle Streams does not support nested tables, so I have downloaded EDS package (Extended Datatype Support package note 556742.1) but it seems that nested tables are unsupported by this package:
0