a2zinterviews

9.	How can you set DML handler?
	DML handler can be set by using the following statement: Dbms_apply_adm.set_dml_handler (object_name, object_type, operation_name, error_handler, user_procedure, apply_db_link)
	Discuss Your Name Your Email-ID Your Answer

10.	Why is additional supplemental logging needed?
	Default logging process records the information about DML operations. Supplemental logging is required to identify the rows to be updated on each destination.
	Discuss Your Name Your Email-ID Your Answer

11.	What is oracle streams?
	The oracle streams product from Oracle Corporation encourages users of Oracle databases to propagate information within and between databases. It provides tools to capture, process (stage), and manage database events through Advanced Queuing Queues.
	Discuss Your Name Your Email-ID Your Answer

12.	How can you find the setup of lob_assembly?
	You can find the setup of lob_assembly by using the DBA_APPLY_DML_HANDLER view.
	Discuss Your Name Your Email-ID Your Answer