Abstract: The principle concept is to dispose of all of the triggers used within the oracle database in Uno product. Heading off auto era of primary key values whilst inserting or updating with the aid of doing away with all of the dependencies on triggers. A primary key's column or columns that include values that uniquely identify each row in a table. A database table need to have a primary key for to insert, update, restore, or delete statistics from a database. This is either done by a saved PL/sq. block or a PL/square, C, or Java technique associated with a desk, view, schema, or the database itself. Oracle Database mechanically executes a cause while a detailed occasion takes location, which may be inside the shape of a machine occasion or a DML announcement being issued against the desk. Oracle GoldenGate is a era that lets in the oracle database in active-lively mode and calls for applications to observe strict rules for the replication to work smoothly without breaking. UNO platform became changed according to the GoldenGate regulations to assist oracle active-energetic database.


PDF | DOI: 10.17148/IARJSET.2022.9696

Open chat