Database Dump

This project is designed to use SQLcl to dump the database objects for the connected SCHEMA to the filesystem.

dmdump requires the SQLcl bin directory to be in your PATH.

Prerequisites

Download and unzip SQLcl.
Add the SQLcl bin directory to your PATH.

Install

Clone or download dmdump onto your system.

Unix

Create a symbolic link to the script dmdump.sh:

sudo ln -s /opt/dmdump/dmdump.sh /usr/bin/dmdump

Windows

Add dmdump to your PATH:
```
SET PATH=%PATH%;C:\dmdump\
```

Usage

Navigate to the desired output directory.
Run dmdump as follows:
```
dmdump {connect_string}
```

Arguments

Name	Description	Example
connect_string	The connect string to connect to a database using `sqlcl` on the command line. Note: A password is required at this stage.	- hr/hr@//server:port/service_name - hr/hr@//server:port:sid - hr/hr@XE1

Sample Output

.
├── function
│   └── GET_NAMES.sql
├── index
│   ├── COUNTRY_C_ID_PK.sql
│   ├── DEPT_ID_PK.sql
│   ├── DEPT_LOCATION_IX.sql
│   ├── EMP_DEPARTMENT_IX.sql
│   ├── EMP_EMAIL_UK.sql
│   ├── EMP_EMP_ID_PK.sql
│   ├── EMP_JOB_IX.sql
│   ├── EMP_MANAGER_IX.sql
│   ├── EMP_NAME_IX.sql
│   ├── JHIST_DEPARTMENT_IX.sql
│   ├── JHIST_EMP_ID_ST_DATE_PK.sql
│   ├── JHIST_EMPLOYEE_IX.sql
│   ├── JHIST_JOB_IX.sql
│   ├── JOB_ID_PK.sql
│   ├── LOC_CITY_IX.sql
│   ├── LOC_COUNTRY_IX.sql
│   ├── LOC_ID_PK.sql
│   ├── LOC_STATE_PROVINCE_IX.sql
│   └── REG_ID_PK.sql
├── package
│   ├── FOO.pkb
│   └── FOO.pks
├── procedure
│   ├── ADD_JOB_HISTORY.sql
│   ├── NAMED_NOTATION_DEMO.sql
│   └── SECURE_DML.sql
├── sequence
│   ├── DEPARTMENTS_SEQ.sql
│   ├── EMPLOYEES_SEQ.sql
│   └── LOCATIONS_SEQ.sql
├── table
│   ├── COUNTRIES.sql
│   ├── DEPARTMENTS.sql
│   ├── EMPLOYEES.sql
│   ├── JOB_HISTORY.sql
│   ├── JOBS.sql
│   ├── LOCATIONS.sql
│   └── REGIONS.sql
├── trigger
│   ├── SECURE_EMPLOYEES.sql
│   └── UPDATE_JOB_HISTORY.sql
├── type
│   └── CL_VARCHAR2_TABLE.sql
└── view
    ├── EMP_DETAILS_VIEW.sql
    └── V_MY_VIEW.sql

tschf / dmdump

readme