rchick/DBFingerPrint
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
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.
About
DB Fingerprint Util written in Java to gain unique key for an Oracle DB schema, so environments can be compared at a very high level
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published