/oracle-dbops

Export all Oracle DDLs for database tracking in a DevOps development cycles. Allow for repo-based code, work, and deployment tracking using tools like GitHub and Azure DevOps

Primary LanguageShellMIT LicenseMIT

DBOps (Oracle)

oracle

This repository is configured to take snapshots of database object DDLs. This is to assist with the tracking database changes over time.

Usage

First time Setup:

Ensure DBA directories are created:

-- /aux/dbops can be replaced with your directory of choice
CREATE OR REPLACE DIRECTORY DDL_TABLE_DIR AS '/aux/dbops/tables';
CREATE OR REPLACE DIRECTORY DDL_VIEW_DIR AS '/aux/dbops/views';
...
CREATE OR REPLACE DIRECTORY DDL_PACKAGE_DIR AS '/aux/dbops/packages';
CREATE OR REPLACE DIRECTORY DDL_PROCEDURE_DIR AS '/aux/dbops/procedures';
CREATE OR REPLACE DIRECTORY DDL_TRIGGER_DIR AS '/aux/dbops/triggers';

Create the folder structure

./create_dirs.sh

Clean any previous runs

./rm_sql_clean.sh

Execute

To run DDL export, execute EXPORT_DDL_DRIVER.sql in Oracle as dba

Error handling

Errors are output to error_log.txt

Contributors