ChkDB |
Open Source Rule-Based Data Checking |
|
Home Contact Download Releases Open Source License Project Contributing The PL/SQL Using ChkDB Installation Read-Me Rule-Sets ChkDB Tables E-R Diagram
Tiny Sample External Links Data Quality and Data Profiling (a glossary) |
Downloading and Installing ChkDBThis is the INSTALL.txt file that comes with a ChkDB distribution (without the license section)...
=================================================================
INSTALL.txt - Installing ChkDB Rule-Based Data Checking
Contents:
Downloading a Distribution File
Unpacking a Distribution
Installing in a Database to be Checked
Uninstalling ChkDB
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Downloading a Distribution File
Download a ChkDB distribution file for your system
(Windows or Unix/Linux) from www.chkdb.org. Go to the
Download page, click on the appropriate link, and let
your browser save the file on your system.
Move the distribution file to an empty directory.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Unpacking the Distribution
In Windows, unzip the distribution file with a zip
application or, in a command window:
unzip chkdb01.zip (or whatever the filename is)
In Unix/Linux, in a terminal window:
tar -xzf chkdb01.gz (or whatever the filename is)
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Installing in a Database to be Checked
Before ChkDB checking can be done in an Oracle database,
five ChkDB tables must be created and a PL/SQL package
must be stored.
Either execute setup_chkdb.sql using SQL*Plus
OR execute the individual scripts yourself:
- chkdb_tables.sql to create 5 ChkDB tables
- chkdb_software.sql to store a PL/SQL package
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Uninstalling ChkDB
The ChkDB tables and PL/SQL can be removed from a database
by executing:
remove_chkdb.sql
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
|