Interested to Buy Any Domain ? << Click Here >> for more details...
When will the data in the snapshot log be used ?
- 2 Answers
- 5248 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 Privilege Auditing ?
what is the step for rmanbackup?
What are the use of Roles ?
What dynamic data replication ?
What are the various type of snapshots ?
What are the different Levels of Auditing ?
What is a trace file and how is it created ?
When will the data in the snapshot log be used ?
What is user Account in Oracle database ?
What is Statement Auditing ?
What are the roles and user accounts created automatically with the database ?
What are roles ? How can we implement roles ?
Oracle General 
