Suppose if someone drops table accidentally belonging to tablespace "tbs3" at Morning 10 am. I want to perform point in time recovery of that particular tablespace until 9:30 am.
Should I perform whole database recovery as there could be dependencies with other tables belonging to a different tablespace . Now, if I recover whole database until 9:30 am . I may also lose the changes happened in other tablespaces b/w 9:30 am to 10am .
Then I should perform tablespace recovery only.
But how to see if any other tablespaces which are dependent on this one should be recovered also?
Kindly assist, thanks in advance.