Interested to Buy Any Domain ? << Click Here >> for more details...
When will the data in the snapshot log be used ?
- 2 Answers
- 5222 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 |
How can you Enforce Refrencial Integrity in snapshots ?
What are the dictionary tables used to monitor a database spaces ?
What is user Account in Oracle database ?
What are the database administrators utilities avaliable ?
What are Roles ?
What dynamic data replication ?
What is the use of ANALYZE command ?
What are roles ? How can we implement roles ?
Differentiate simple and complex, snapshots ?
How will you enforce security using stored procedures ?
What are the different Levels of Auditing ?
What are the roles and user accounts created automatically with the database ?
Oracle General 
