383rd questions, 053383

383rd questions, 053383
383. At the request of a user, you issue the following command to restore a dropped table: flashback table
"BIN $ F2JFfMq8Q5unbC0ceE9eJg = $0" to before drop; Later, the user notifies you that the data in
Table seems to be very old and out of date.
What might be the problem?
A. Because a proper range of SCNs was not specified, the wrong data was restored.
B. A proper range of timestamps was not specified, so the wrong data was restored.
C. A previous Flashback Drop operation had been stored med, resulting in multiple versions of the table
Being stored in the Recycle Bin.
D. Either option A or B cocould be correct. Not enough information was provided to determine which.
E. None of the above.
Answer:E

The answer to the original question is E. For some versions, the answer is C. I think the correct answer is E.

First, the flashback drop command does not specify the SCN or TIMESTAMP option, so ABD is incorrect. Then, the flashback drop command does not create objects in the recycle bin, So C is incorrect.

When the processing recycle bin contains multiple objects with the same original name, you can use the unique name of the object in the recycle bin, as shown in the question. The most likely cause of this question is that DBA has incorrect judgment on the object drop time in recycle bin, resulting in the use of the wrong unique name.

You can also retrieve any table from the recycle bin, regardless of any collisions among original names, by using the unique recycle bin name of the table. For example, assume that you query the recycle bin as follows (sample output sorted DED ):

SELECT object_name, original_name, createtime FROM   recyclebin;    OBJECT_NAME                    ORIGINAL_NAME   CREATETIME------------------------------ --------------- -------------------BIN$yrMKlZaLMhfgNAgAIMenRA==$0 TEMP_EMPLOYEES  2007-02-05:21:05:52BIN$yrMKlZaVMhfgNAgAIMenRA==$0 TEMP_EMPLOYEES  2007-02-05:21:25:13BIN$yrMKlZaQMhfgNAgAIMenRA==$0 TEMP_EMPLOYEES  2007-02-05:22:05:53

You can use the following command to retrieve the middle table:

FLASHBACK TABLE BIN$yrMKlZaVMhfgNAgAIMenRA==$0 TO BEFORE DROP;

Reference: http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmflash.htm#BRADV81330

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.