LOGICAL Data Guard: Is "update table...where rowid='xxxx'...." supported in the PRIMARY?
edited Mar 6, 2012 1:55AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 2 comments
Hello colleagues,
I have a doubt about LOGICAL data guard behavior. Not installed yet, but planning to do it.
We use, In the primary database, a lot of queries of this type:
"update table t ... where rowid=xxxxxx;"
I know rowid datatypes are not supported in Logical Data Guard. No problem, We don´t have any, but:
- Is it supported to use the internal column rowid in the where clause?
- Will it fail when trying to replicate the sentence in the stby database, or will the SQL Apply transform the query by using the supplemental logging and do correctly the update?
0