CREATE INDEX does not store the timestamp of the most recent function used - Oracle

Q.  CREATE INDEX does not stores the timestamp of the most recent function used in the function-based index.
- Published on 27 Jul 15

a. True
b. False

ANSWER: False
 

    Discussion

  • Nirja Shah   -Posted on 29 Sep 15
    - The above statement is false.

    - The true statement is:

    - "CREATE INDEX stores the timestamp of the most recent function used in the function-based index."

    - This timestamp is updated when the index is validated.

    - When performing tablespace point-in-time recovery of a function-based index, if the timestamp on the most recent function used in the index is newer than the timestamp stored in the index, then the index is marked invalid.

    - You must use the ANALYZE INDEX ... VALIDATE STRUCTURE statement to validate this index.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)