Why "Advanced Queuing does not support Tablespace Point-in-Time Recovery (Doc ID 137237.1)"
Hello!
Can someone shed light on why TSPITR is not supported with AQ objects?
What property does an AQ queue table or other supporting object have that interferes with TSPITR?
And also: why is it not a problem with database point-in-time recovery?
In my example I have one single and one multi consumer queue table.
SYS@buda>r
1 SELECT OBJ1_OWNER, OBJ1_NAME,OBJ1_TYPE,REASON
2 FROM SYS.TS_PITR_CHECK
3 WHERE (
4 TS1_NAME IN ('AQTS')
5 AND TS2_NAME NOT IN ('AQTS')
6 )
7 OR (
8 TS1_NAME NOT IN ('AQTS')
9 AND TS2_NAME IN ('AQTS')
10* )
own1 name1 obj1type reason
------ ------------------------- -------- ---------------------------------------------