It is not possible. As triggers are defined for each table, if you use COMMIT of ROLLBACK in a trigger, it affects logical transaction processing.
yes WE can use COMMIT and ROLLBACK triggers, but by using PRAGAMA AUTONAMOUS_TRANSATIONS. Now the transation treated as a autonomous tansation.
What is the difference between physical and logical backups?
Tell me is it possible to specific tables when using RMAN DUPLICATE feature? If yes, how?
Explain the steps for changing the DBID in a cloned environment?
How RMAN improves backup time?
What is the difference between obsolete RMAN backups and expired RMAN backups?
Explain the steps for recovery with missing online redo logs?
How would you speed up the RMAN backup of a 500GB database?
Tell me what is the meaning of configure encryption algorithm in rman and why we need to set this parameter in rman configuration?
Explain what is the significance of incarnation and DBID in the RMAN backups?
Tell me the steps involved in CANCEL based recovery from the full database from hot backup?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
