When will the data in the snapshot log be used ?
Answers were Sorted based on User's Feedback
Answer / shailendra kumar
snapshort log is used updated data for master table and if
any recored is updated after certen peried to referse the
master table collect the snapshot log. because tha table
size is very large it take lot of time. thus by ues the
snapshot log.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
what is meant by physical order and logical order in clustered index and non clustered index.
What is Statement Auditing ?
How can you Enforce Refrencial Integrity in snapshots ?
What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?
What are the database administrators utilities avaliable ?
What are the options available to refresh snapshots ?
What is a profile ?
How will you enforce security using stored procedures ?
what is different between view and sequence?
What is a trace file and how is it created ?
How can we reduce the network traffic ?
What are the different Levels of Auditing ?