When will the data in the snapshot log be used ?

Answer Posted / guest

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).

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category