Repositório de backup e versionamento de objetos metadados Oracle

Abstract

Developing systems and common to program several types of Objects metadata. In Oracle Database Some these objects are known as: tables, views, indexes, triggers, primary keys) and foreign keys, stored procedures, functions, other between. As processes objects are created in the bank, there is always a need to perform support these objects paragraph metadata later retrieves them in case of a need. Using some tools que Oracle Perform This paragraph provides process security and Recovery copy Were Some Problems identified que usually comes Developer facing, and these problems are a: do not have the required knowledge paragraph handling of these tools or do not have the required access . Based on this situation studied a solution was create a Repository Within the Oracle database, able to choose Developer what objects want to do backup and recovery without que Let there be a need to hum database administrator Make This Work, because the repository will store the DDL scripts OS (Data Definition Language) and procedural complete code each object created, and whenever there is an update in its definition, IT contemplating versioning for the modification of data objects from the Current Version To Previous versions.