passing 'GRANT OBJECT', 'REVOKE OBJECT' as STMT parameter in DBMS_LOGSTDBY.SKIP
edited Feb 11, 2010 1:07AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
Hello All,
A colleague of mine was fiddling around with the DBMS_LOGSTBY.SKIP procedure, and asked me to verify if he can pass GRANT OBJECT and REVOKE OBJECT as the STMT parameter. It seems that these statements were listed in the 10.1 documentation, but disappeared in 10.2.
His current dilemma is that, while it did solve his problem, he isn't sure if it is "officially" supported, since it isn't specifically listed in the latest 10.2 documentation -- i.e. it might become unsupported in future releases(we haven't tried it on 11G yet)
Can anyone fill me in? tia
A colleague of mine was fiddling around with the DBMS_LOGSTBY.SKIP procedure, and asked me to verify if he can pass GRANT OBJECT and REVOKE OBJECT as the STMT parameter. It seems that these statements were listed in the 10.1 documentation, but disappeared in 10.2.
His current dilemma is that, while it did solve his problem, he isn't sure if it is "officially" supported, since it isn't specifically listed in the latest 10.2 documentation -- i.e. it might become unsupported in future releases(we haven't tried it on 11G yet)
Can anyone fill me in? tia
0