The dbfingerprint from ztz2018

dbfingerprint's Introduction

This Util gives you a high level fingerprint of a Oracle DB schema. 

Hopefully people will find this Util useful when comparing Oracle environments, (between dev, test, prod) and when upgrading stacks to make sure environment control is in place and environments are like for like.

It runs the following SQL against the supplied details

Description       - SQL
Oracle Version    - "select * from v$version"
Number of Tables  - "SELECT COUNT(TABLE_NAME) FROM ALL_TABLES"
Number of Columns - "select count(column_name) from all_tab_columns"
Number of Indexes - "select count(index_name) from all_indexes"
Number of Views   - "select count(view_name) from all_views"
DB Character Set  - "select value from nls_database_parameters where parameter='NLS_CHARACTERSET'"

then displays the details on a single line. 

EXAMPLE OUTPUT:-
###############

version.tableCount.columnCount.indexCount.viewCount.characterSet
"Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production".553.13764.1078.825."WE8ISO8859P15"

###############
To run use

Syntax: java -classpath <oracle-driver> -jar DBFingerPrint.jar <JDBC URL> <username> <password>
   <oracle-driver> The full path to the Oracle driver jar file - either classes12.zip or ojdbc14.jar will suffice
   <JDBC URL> db schema full JDBC URL.
   <username> db schema Username.
   <password> db schema Password.

Recommend Projects