Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TableSpace PITR

Status
Not open for further replies.

ErrolDC2

MIS
Apr 6, 2005
43
US
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:

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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top