When will the data in the oracle snapshot log be used?
Submitted by: AdministratorWe 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).
Submitted by: Administrator
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).
Submitted by: Administrator
Read Online Distributed Processing Job Interview Questions And Answers
Top Distributed Processing Questions
☺ | How can you Enforce Referential Integrity in oracle snapshots? |
☺ | What is Oracle Distributed database? |
☺ | When will the data in the oracle snapshot log be used? |
☺ | What is an oracle SNAPSHOT? |
☺ | What are the options available to refresh Oracle snapshots? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |