Snapper aka OraSnap
================

The program
------------------
Orasnap is based on the SQL code and HTML output as used/generated by Orasnap 2.4 (http://www.stewartmc.com/oracle/orasnap/). It is basically the same output but the program has been reduced to a single executable with a total size of about 434 Kb. It differs from OraSnap in that it can run interactively and it can be run in batch-mode (generating HTML or ASCII files). 

How to use
----------------
Unzip snapper10 in a directory of you choice. Apart from snapper.exe you'll find the Delphi 5 code which makes up the program (see the source code section of this document). Basically you have to way's to connect to the Oracle database:
1. Start snapper.exe and choos 'Connection -> Oracle client'. You will have then to enter your username, password and TNSNAMES.ORA entry.

2. Start snapper.exe and choose 'Connection -> Direct'. This requires you to provide the following information: username, password and server string. The serverstring has the following syntax : <ipnumber Oracle server>:<Listner port>:<SID>. For example : 172.16.1.10:1521:OMNIA

Option 2. has as an advantage (over option 1) that it is somewhat faster and that is does not need any kind of Oracle client software on your client computer.

After a succesful connection you can choos to generate any of the reports on the left side on the screen, on  the bottom panel the explanation of what the numbers mean is shown. When you press the 'SQL' button you see the SQL that's used to generate the results (pressing 'Txt' shows the explanation again).

If you want to generate one or more HTML/ASCII reports you have to choose 'Output -> Batch'. You'll be able to select one or more reports and to specify wether the report are generate in ASCII or HTML. 

Note: several reports create a temporary view that's deleted upon leaving the program. If you have insufficient rights the program will not display the results and/or stop the batchprocessing.

Source code
------------------
Included is the Delphi source code of the program. For recompiling you'll need Delphi 5, ODAC (www.crlab.com) and 1stClass (www.woll2woll.com). There are no restrictions on using this source.

License/Copyright
-------------------------
The complete package is provided as freeware, the SQL code is (c) Stewart McGlaughlin. You can give this program/zip-file away, you can not charge money for this however.

Disclaimer
---------------
The program is provided as is, if it doesn't work and/or provides you with incorrect data then it's up to you to correct this. Any kind of warranty is explicitly NOT given.

Notes
--------
The program at this moment works best using SYS as the connecting user. In the next version I hope to have implemented the following:
- changes from Orasnap 2.5.0
- better checks on the ability to create views
- no stopping of the batch process if the user has not sufficient rights to create certain views.

regards
Martin Brekhof
martin@brekhof.nl