Interested to Buy Any Domain ? << Click Here >> for more details...
When will the data in the snapshot log be used ?
- 2 Answers
- 5250 Views
- I also Faced
- E-Mail Answers
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 a trace file and how is it created ?
What are the different Levels of Auditing ?
What is snapshots ?
what is meant by physical order and logical order in clustered index and non clustered index.
How can you enable automatic archiving ?
What are the minimum parameters should exist in the parameter file (init.ora) ?
What are the various type of snapshots ?
What are the options available to refresh snapshots ?
What is Auditing ?
What is Privilege Auditing ?
How will you enforce security using stored procedures ?
What is Object Auditing ?
Oracle General 
