Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Type does not supported

User_RWYAYAug 31 2017 — edited Aug 31 2017

Hi, Srs.

I have small doubt about Data Type does not supported on Data Guard.

I have an exadata environment and i will migrate from 11.2.4.0 to 12.2.1.0 using physical dataguard, after that convert to logical standby.. i want to know what is the data type does not support on logical standby.

I saw at - https://docs.oracle.com/cd/E11882_01/server.112/e41134/data_support.htm#SBYDB00305:

Logical standby does not support tables that contain only the following datatypes:

LOB (CLOB, NCLOB, BLOB)

But, if you see at https://docs.oracle.com/cd/E11882_01/server.112/e41134/data_support.htm#SBYDB4936

C.1.2 Unsupported Datatypes in a Logical Standby Database

The following data types are not supported by Logical standby databases. If a table contains columns having any of these unsupported data types, then the entire table is ignored by SQL Apply.

BFILE

Collections (including VARRAYS and nested tables)

Multimedia data types (including Spatial, Image, and Oracle Text)

ROWID, UROWID

User-defined types

Its confused... What the true?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2017

Added on Aug 31 2017

#data-guard, #performance-availability

1 comment

503 views