What happens to a tablespace when its recovery infromation
has been removed and a full recovery is no longer possible?
Answers were Sorted based on User's Feedback
Answer / vat
it goes into 'COPY' - Copy Pending status. You would have
to perform a full image copy to reset the status. That's
why you never do MODIFY RECOVERY and delete ALL image copies
of the table.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / s
Tablespace in intact. You can make a image copy of the
tablespace to make it recoverable.
Is This Answer Correct ? | 0 Yes | 0 No |
what is differnece between DROP TABLE & DELETE TABLE .
What is the format (internal layout) of ?TIMESTAMP??
is it possible to get -811 error when you use cursors. why?
What is a cursor?
What is correlation names?
What is tablespace?
What does sqlcabc has?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Do we need cursor for Count(*)?
What is the use of commit in db2?
What is meant by explain?
What is the picture clause of null indicator variable?