No, TSPITR should not be the preferred method. Why not ? Because it doesn't guarantee that you have achieved consistency of data across objects. You must still export the "related objects" and bring them in.
Suppose you have a transactions which updates tables in three different tablespaces. A TSPITR for one tablespace would have one table "older" than the other two. Similarly, indexes in a seperate tablespace are inconsistent with the data and must be recreated.
TSPITR is to be used only when you cannot do a full recovery AND you can gaurantee that you can recover data consistency.
Hemant
At 11:09 PM 28-06-03 -0800, you wrote:
Hello list I came across the following question in the TMH exam guide for 1z0-032:
Chris, a DBA, while performing maintenance tasks accidentally drops a very important table. What is the best method available for Chris to recover this table if he is aware of the time when the table was dropped?
A . Change-based recovery
B*. Point-in-time recovery
C . Tablespace point-in-time recovery
D . Cancel-based recovery
Answer : Point-in-time recovery
Wouldn't TSPITR be the best method available in general ?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).