Hi. I'm researching our capability for TSPITR and I got some docs, books and etc. In checking to see if we have the ability, I got some information from querying the ts_pitr_check table that I don't know how to translate. Can someone help me understand what the issue is. According to my understanding, ts_pitr can determine if an object is transportable.
Forgive me if the formatting comes out wrong. I did my best to make it readable:
What does it mean that the constraint is not containted int he recovery set?
Forgive me if the formatting comes out wrong. I did my best to make it readable:
Code:
own1 name1 obj1type reason ts1_na
------ ----- -------- ------------------------- ------
CAPDBA DOCTY TABLE constraint between tables CAP
PE not contained in recovery
set
CAPDBA DOCTY TABLE constraint between tables CAP
PE not contained in recovery
set
CAPDBA DOCTY TABLE constraint between tables CAP
PE not contained in recovery
set
own1 name1 obj1type reason ts1_na
------ ----- -------- ------------------------- ------
CAPDBA DOCTY TABLE constraint between tables CAP
PE not contained in recovery
set
CAPDBA DOCTY TABLE constraint between tables CAP
PE not contained in recovery
set
CAPDBA DOCTY TABLE constraint between tables CAP
PE not contained in recovery
set
**snip**
65 rows selected.
What does it mean that the constraint is not containted int he recovery set?