DEVFYI - Developer Resource - FYI

When will the data in the snapshot log be used?

ORACLE Interview Questions and Answers (Part 1)


(Continued from previous question...)

95. When will the data in the snapshot log be used?

We must be able to create a after row trigger on table (i.e., it should be not be already available) After giving table privileges. We cannot specify snapshot log name because oracle uses the name of the master table in the name of the database objects that support its snapshot log. The master table name should be less than or equal to 23 characters. (The table name created will be MLOGS_tablename, and trigger name will be TLOGS name).

(Continued on next question...)

Other Interview Questions