Contact
 
info@impact-sol.com

==========================
INSTALLATION INSTRUCTIONS
==========================

1.  Unzip Guggi.zip.  It will unzip Guggi.msi, which is a 
self-installation package.
2.  Double-click on Guggi.msi.
3.  The installer will be launched.
4.  If the installer detects a previous version of Guggi, it will ask 
whether you want to remove or repair Guggi.  Select remove Guggi.
5.  Once the previous version is removed, double-click on Guggi.msi 
again and it will install the latest version.  This way the installation 
is always clean.

You may need to download MDAC ver 2.7 or 2.8 to connect to Oracle using 
OLEDB made by Microsoft. MDAC is available from www.microsoft.com

It is recommended that Oracle's OLEDB which is also the native driver to connect 
to Oracle be used.  OleDB can be installed when you install Oracle Client on your PC.


It is recommended that the ODBC driver provided by Oracle be used to 
connect to Oracle if you want to use the ODBC connection instead of OLEDB 
connection.  Connection as SYSDBA and SYSOPER is supported via ODBC 
connection using ODBC driver made by Oracle (version 9.2 and higher)

********************************************************************************

IMPORTANT:  In order to run DML statements in the background or to compile PL/SQL code in the PL/SQL editor, Oracle Objects for Ole (OO4O) should be installed on the machine where Guggi Oracle is installed.  OO4O can be installed from the Oracle Client CD.  In most
cases if you have Oracle client installed, then the chances are OO4O is already installed
and you do not have to do anything.

Check if in ORACLE_HOME/bin folder you have oipXX.dll installed wherer XX=8,9, or 10.
If it exists then you should be all set.

Otherwise ....

If OO4O is not installed from Oracle Client CD then follow the following steps:


OPTION 1: easiest

Download ODAC.exe from http://technet.oracle.com and install the drivers


OPTION 2: Not so straight-forward but easy
1.  In the folder where Guggi Oracle is installed, you will find the following files:
   a. oip10.dll
   b. oip10.tlb
   c. oraansi10.dll
   d. oo4oparm.reg
   e. oipus.msb

Copy oip10.dll, oip10.tlb oraansi10.dll in ORACLE_BASE\ORACLE_HOME\bin folder

Copy oo4oparm.reg in ORACLE_BASE\ORACLE_HOME\oo4o folder

Copy oiplang.msb  in ORACLE_BASE\ORACLE_HOME\oo4o\mesg folder

If the oo4o and oo4o/mesg folders do not exist, then simply create them.

2.  After copying the files, execute the following command at DOS prompt from the folder where oip10.dll is copied  (ORACLE_BASE\ORACLE_HOME\bin)


>  regsvr32 oip10.dll

This will register the dll

3.  Edit the oo4oparm.reg file to enter the correct Oracle_Home and Home_ID.  Save the file
 and execute the following command at DOS prompt from the location where the file is saved.

>    oo4oparm.reg

Please note, examples of Home_ID are ora81, ora90, ora10 etc.


Once OO4O is correctly installed, you should be able to run DML in background and compile PL/SQL code


If the above process seems too complicated them simply install Oo4O from your client CD.


***********************************************************************************

PLAN_TABLE is provided with the download as a SQL script.  Execute the script to create
the table.  Explain Plan cannot be used until the plan table exists.


PLEASE NOTE:  Every version of Guggi-Oracle expires in about 30 - 45 days.


------------------------------------
KNOWN ISSUES
------------------------------------

NOTE about Syntax Highlighting

Syntax highlighting is almost done and is being currently QA'd.  The only feature to be worked on is to highlight a string that contains single quotes around variables.


=============================
Change Log
=============================

New/ Changes in Version 2.1.0 - Released March 21, 2006

1. Enhanced SQL History feature.  Only distinct SQL statements are displayed when the
SQL history form is opened.  User has the option to delete all SQL statements.
2.  Data filter on tables has been improved.  Now the application remembers filter condition applied on different tables.
3.  Data edit in table ... fixed fnctionality of rollback and commit
4.  New tree view for schema browser in addition to tabbed view.  Number of visible object types are limited in treeview.
5.  Enhanced Schema Compare tool to compare PL/SQL objects such as Procedures, Packages, and Functions
6.  Created buttons for every open window.  Users can goto a window by clicking on the appropriate button instead of selecting window from the drop-down box.
7.  Make Application changes without logging into a database.
8.  Export data to Excel from most of the tools such as Sessions manager, invalid objects manager etc.
9.  SQL Editor now displays whether a query is executing or is complete.  Same in Sessions manager.
10. Improved intellisense - works for DML operations (update / delete) also besides select.
    Also works with both schema name and object name are specified (schema.table_name) in a query.
11. Users can now view JAVA SOURCE code.
12. Added a new DBA tool "Database Objects Overview" that provides an overview of database objects.  The tool is under development.
--------------------------------------------------------------------------
New/ Changes in Version 1.6.2 - Released Jan 31, 2006

1.  Added Schema Compare Tool - preliminary version of the tool.  Compare details
of tables in two different schemas.
2.  Added option to filter objects.
3.  Enhanced PL/SQL editor by making it multi-tabbed.  You can open upto 10 tabs on a 
    single PL/SQL editor window.  Right click on an open tab or click on + sign in toolbar
    to open a new tab.
4.  Fixed filter on data and column selection.  Users can now put filter on data and 
select from a list of columns.
5.  Upgraded Text Output Tab in SQL Editor.  Users can page through the records.  Users can
use bind variables or parameter substitution.
6.  Enhanced Schema browser to manipulate indexes and constraints in the table tab
7.  Improved icons on toolbars.

--------------------------------------------------------------------------

New/ Changes in Version 1.5.9 - Released Dec 22, 2005

1.  Added SQL Access Advisor - Quick Tune, Tune SQL from Cache, Tune SQL from user workload,
Tune SQL for a Schema, Tune MV.   These features are relevant for Oracle 10g only.

2.  Added support for query execution using bind variables. Support is provided for Date,
String and Number bind variables. 
Also, the user can have both replacement and bind variables in the same query.

Note: If the parses inccorectly picks a string as a bind variable (e.g., in date format displaying hh24:mi:ss), the datatype should be selected as "Ignore-Not bind variable".  

3.  Added the Text Output Tab to SQL Editor.  Query returns all the records.

Click on Text Output tab
Execute the SELECT query

Output will be displayed in text format (just like in SQL*Plus)

Note: Entire resultset will be printed if the Text Output tab is selected.  The
user does not have the option to page through the results.  So take caution if the 
query will return a large number of records.


3.  Made the forms moveable.  After debating a lot, we have decided to make the forms running within the application moveable.

4.  Added right-click menu to some more object types (procedures, packages, types etc.) in the schema browser

5.  Enhanced functionality of SQL editor and PL/SQL editor.  By pressing Ctrl-[, name of the 
objects that match the selection will be displayed in a pop up box.  For example, type

select * from sa

Now press Ctrl-[

A list of objects including table SALGRADE will be displayed.  Now the user can select, salgrade and it will complete the SQL as follows

select * from salgrade

--------------------------------------------------------------------------

New/ Changes in Version 1.5.6 - Released Nov 30, 2005

1.  Added a new tool called Stored Procedure Helper.  Execute stored procedures 
and view the output.   Support provided for ref cursors (upto 10 ref cursors), varchar2,
 char, number and date.  User can now view the data in the ref cursors returned by the 
stored procedure (package, procedure, function).  Input and output values are visible in the tool.

2.  Enhanced the Quick ERD tool.  Earlier the tool displayed a maximum of 9 related tables.
The tool now has no such limitations.  User can now page through the related tables, and 
all table relationships are now displayed in sets of 9.

3.  Enhanced create database link to create shared, current user and connected user links.

4.  Added icons to database links pane to indicate public or private links.

5.  Added icons to trigger pane to indicate enabled (yellow bullets) or 
    disabled (blue bullets) status.

6.  Added icons to rollback segment pane to indicate online (yellow bullets)  or 
offline  (blue bullets) rollback segments.

7.  Added icons to schema pane in schema browser to indicate open or locked accounts.  This is available only if DBA% views option is selected in Application Options.

8.  Added extra functionality to create dblink screen.

New/ Changes in Version 1.5.3 - Released Nov 7, 2005

1.  Redesigned reverse engineer tool.  Now the user can reverse engineer all the objects
(Oracle ver. 9.2 upwards).  The user can also reverse engineer a selected list of objects
of a given object type.  For example, the user can select to reverse engineer 5 of 10 tables in a given schema.  
There is an option to select objects from ALL_OBJECTS or DBA_OBJECTS view.

2.  Added run till exception, abort execution to PL/SQL debugger.  Improved error messaging 
in debugger.

3. Added support for all object types in SQL editor.  Support for object tables is planned for next release.

4. Enhanced Sessions Manager to show I/O stats, current waits, wait events, session stats etc.

5. Added sort on click to Storage Manager grids.

6.  Moved some tools such as Rollback Segment manager, Sessions Manager etc. under Database and DBA tab since these tools are truly DBA tools.

7.  Added right-click menu to sql editor, plsql editor, schema browser object panes

8.  User can now execute SQL statements ending in a semi-colon (";").  The user no longer gets the "Invalid Character"    error.

9. Added the functionality to view data from sql query in a textpad in SQL window.

10.  Added the application option to run DML either in background thread or in the main SQL Editor window.

-------------------------------------------------------------------------------------

New/ Changes in Version 1.5.0 - Released Oct 5, 2005

1.  Added PL/SQL Debugger.  This was a long-pending tool to be added to Guggi Oracle.  This provides a significant enhancement to PL/SQL abilities along with code compilation, profiler and trace.

Debugger Supports: Step into, Step over, Step out, add breakpoint, delete breakpoint, get value, set value, variable watch list, stack trace.

Run till excecption will be added in the next release

How to use the debugger:

	a.  Launch the debugger from Tools menu option
	b.  Type in a PL/SQL anonymous block.  Anonymous block is needed for all PL/SQL code - package, procedure, function
	c.  Click on first button - start debugger
	d.  Click on continue or step into or step over or step out
	e.  Enter the watch variables in the lower left grid and values will be displayed in the grid.
	f.  Once the debugging is done, the first and last button will become enabled and other buttons will be disabled.


2.  Added latch Monitor -  a DBA tool.  View latch holders and latch waiters.
3.  Improved the DDL for tables - added indexes and constraint scripts
4.  Consolidated free space tablespace and object space into Storage Manager.  View space taken by objects in a given schema.  View space taken by objects in a given tablespace.
5.  Added several editing features to the SQL and PL/SQL editor
6.  Improved the sizing of the controls on severl windows as waits-latch-lock, upload blob, view image, SQL stats etc.
7.  Added User Guide.
8.  Much more ...


New/ Changes in Version 1.4.7 - Aug 25, 2005

1.  Added Quick ERD tool.  The tool can be accessed from the Schema Browser by clicking on the sixth icon.
    The tool shows the relationship the selected table has with other tables in the same schema.  Relationship with tables
    in other schemas is not shown.  If the table has a foreign key (FK) which is also a part of the primary key (PK) then the     Quick ERD tool will show the column as FK but not both.

2.  Enhanced Synax highlighting.  

3.  Updated SQL Editor - 
  	a. records can be retrieved in increments of 25
        b. all records can be retrieved from the database
        c. record retrieval can be cancelled
        d. copy explain plan to the clipboard
        e. maintain a buffer of SQL statements in the SQL Editor.  Besides storing SQL statements in the SQL history, the statements are saved in the SQL buffer.  These statements can be retrievevd from the buffer.
Also, enhanced the Guggi SQL*Editor with above features.  Improvevd the Explain Plan.

4.  Enhanced PL/SQL editor to improve syntax highlighting while editing.

5.  Passwords are saved in the registry.  You can logon to the database by double-clicking on the right side user/database list in Login Window.

6.  Added histogram to table details

7.  Added External table and Queue Table tabs.

8.  Added job type details

9.  View object details by pressing ctrl-Q in PL/SQL editor window.

10. Fixed some bugs.



New/ Changes in Version 1.4.5 - July 17, 2005
1.  Added PL/SQL Trace.  This is a good addition to trace PL/SQL calls and can be used
    with PL/SQL profiler to fine tune the PL/SQL code.
2.  Added the feature to execute DML (insert, delete and update) in a background thread.
3.  View the Schema Browser with and without the left pane (one that displays all objects of a given type)
4.  Added the ability to change the control size with SQL Editor, User Schema Manager, Sessions manager, PL/SQL Profiler, Guggi SQL Editor and other forms.  This is in progress.
5.  Press ctrl-Q in SQL Window and a window pops up that displays the details of a given object
6.  Improved the Explain Plan of the Sessions Manager window
7.  No limit on size of PL/SQL code to be compiled
8.  Main menu is now available in multiple languages - English, German, French and Spanish.  The menu language can be adjusted using Application Options.
9.  Added the option to select from ALL% dictionary views or DBA% dictionary views.  
10.  Added option to set the left panel size that displays the list of objects.
11.  Other minor enhancements and bug fixes.


New/ Changes in Version 1.4.4 - June 26, 2005
1.  Added Server Monitor
2.  Enhanced user managed application options
3.  Add several graphical presentation of database features
4.  Sorting of data in grids by clicking on the grid column header


New/ Changes in Version 1.4.0 - June 5, 2005

1. Added PL/SQL Profiler
2. View Temporary objects
3. View the code of the synonym
4. Improved the intellisense 
5. Added graphics for better visualization of data
6. Many more new features which I forgot to document

New/ Changes in Version 1.3.9 - Apr 20, 2005

1.  Change the connection without opening a new form.  You can change the connection while on a screen by clicking on the last button on the main toolbar.  A drop down box will open up and you can select the connection.  The content of the screen will change according to the new connection.

2.  Added more intellisense to the SQL and Procedure editors.
3.  Improved the Explain plan to display the records as a tree.
4.  Addded the Lock manager to view various types of locks.
5.  Edit text columns in the schema browser - Table data display.  It is difficult to edit text columns (varchar2, char, clob) in the datagrid.  Now select the cell you want edit (must contain text data), click on the notepad icon and modify and save data.  Click on the "check mark" to accept and commit changes.
6.  Fixed the display of some the screens (such as procedure, package etc.)
7.  Made it easier to view only text or only data in the SQL editor.
8.  Added line numbers to the SQL editor and Procedure editor text areas.
9.  Fixed some bugs.


New/ Changes in Version 1.3.8 - Mar 10, 2005

1.  Fixed the sort order on SQL History table
2.  Added Single view record of data in a table or a query.  Data can be updated in the single view record
3.  Added parameter identification - when you run a query with input parameters, the application will prompt you to enter the parameter value.  The default parameter character is &.
4.  Modified the statement id of plan table to varchar2(32) from varchar2(200).
5.  View CLOB data in data grid using Oracle OleDb driver
6.  Added intellisense in SQL-Editor to detect a table or view and display it's columns which can then be selected to print on the main SQL Editor window.  The intellisense window opens up when the "." character is typed in the SQL-Editor window.
7.  Added icons to table and index browser (partitioned vs non-partitioned), view, procedure, package (valid vs invalid), constraints (unique, primary key, foreign key), tablespace (undo, permanent, temporary).
8.  Get immediate view of table structure by pressing Ctrl-Q when the cursor is on the table
  name.  Will extend this to view and other object types in the future release.


New/ Changes in Version 1.3.5 - Feb 27, 2005

1.  Modified the application so that the screen controls can adapt to screen resolution.  
Earlier the application dimensions were fixed at 1024 X 768 but now with change in 
screen size the application size changes.
2.  Added Guggi SQL Editor as a built in as well as an independent SQL editor
3.  Added Create Consumer Group Functionality
4.  Added Create Cluster functionality
5.  Added Network Utilities - FTP
6.  Added details for CONTEXT, CONSUMER GROUP, JAVA class, java data, java resource, java source
7.  Added a new object - CLUSTER
8.  Added a new object - DIMENSION
9.  Added a new object - SUMMARY
10.  Added a new object - POLICY
11.  Added Constraint Details
12.  Grouped Java class, data, resource and source under one tab called JAVA.
13.  Minimized Syntax highlighting.  Syntax highlighting is being revamped
14.  Added index partition details
15. Login screen boxes now show the last login username, password and database connection.



New/ Changes in Version 1.3 - Feb 7, 2005

1.  Added View Image manager - view images stored in the database as BLOB.  You can download non-image binary data also.
2.  Added Upload BLOB manager - upload binary files into BLOB columns of the database
3.  Added Create Queue screen - create advanced queues
4.  Added feature to retrieve past SQL statements
5.  Added filter to the Synonym tab
6.  Added the option to kill a session from Sessions Manager window
7.  Added Options feature to set Application level options such as max records, first window after login, font in the sql window
8.  Added more functionality to trigger toolbar such as enable, disable trigger, syntax highlighting
9.  Fixed loading of Triggers and Types into Procedure Editor
10. Added Count of Records to tables data tab
11. Fixed Save button bug in SQL / PLSQL window
12. Added column to table column list to indicate whether the field is nullable 
13. Fixed loading of package code in PL/SQL editor.  Code is loaded after displaying it first
14. Fixed the SQL editor so that you can put comments in the SQL code 
    even when connected using Oracle's OLEdb
15. Improved syntax highlighting


New/ Changes in Version 1.2 - Jan 27, 2005

1.  Backup Manager
2.  Cache, Control Files
3.  File and System I/O Stats
4.  Modified Latches, Locks Waits
5.  More functionality for Advanced Queues such as stop and start dequeue and enqueue
6.  Added Sequence Report

7.  Improved the Procedure Editor and SQL editor :  view columns for tables while writing the code

8.  Compile large PL/SQL blocks (more than 32K characters in size)

9.  Compile PL/SQL blocks using both Microsoft OLEDB and Oracle OLEDB

10. Compile all objects - packages, procedures, views


New/ Changes in Version 1.1 - Jan 16, 2005

1.  Analyze Manager - analyze database tables and indexes
2.  Rollback Segment Manager - analyze what transaction each rollback 
segment is supporting
3.  SQL Stats Manager - SGA trace and see hot statement and hot tables
4.  User/Schema Role Manager - Manage user security, grant and revoke 
privileges
5.  Added the functionality to create a Rollback Segment
6.  Functionality to close a single connection or all connection with 
the option to commit or rollback
7.  Functionality to reopen a closed connection by right-clicking on 
the applicable button at the bottom of the application
8.  Added a new report for Tables and constraints
Enhanced GUI
8.  Improved Invalid Objects Manager to compile invalid objects.  
Objects can be recompiled from the Schema Browser also
9.  Added filter to View Linked Data functionality.  Now you can filter 
data from the starting parent table10.  Fixed the filter on Table and 
View data so that the filter condition is not lost once the filter is 
closed.
11.  Fixed the Explain plan statement

----------------------------
Version 1.0.0  - Jan 1, 2005
----------------------------

Introduced Guggi-Oracle with the following features and functionality


1 Browse the database for 28 different types of objects such as table, 
view, synonym, function, index, trigger, sequence, schema, tablespace, 
procedure, package, java class, materialized view, database link, type, 
rollback segment, directory, operator, library, queue, java data, java 
source, java resource, context, consumer group, index type and job

2 Tab through the properties of database objects

3 Create database objects such as constraint, database link, directory, 
index, sequence, synonym and table through a simple user interface

4 Filter the table and view data

5 Add, delete, and update data (to a table) using a simple grid 
interface

6 Read the PL/SQL code behind views, procedures, packages, functions, 
triggers, and types

7 Generate the script for tables, indexes etc

8 Reverse engineer objects from an exiting database

9 Set the maximum number of records to be returned by a query or when 
you scroll the data in a table

10 Check the free space in the database for individual datafile and for 
tablespaces

11 Go through the session history. Check the current SQL and percent 
complete

12 Check the instance summary, latches, locks and waits

13 Review the Oracle database parameters

14 Check the current registry Oracle related registry values on your 
local computer

15 Generate reports

16 Determine statistical parameters such as minimum, maximum, average, 
standard deviation, variance, standard error, kurtosis, skewness of 
data stored in tables

17 Quick link to SQL*Plus

18 Use a scientific calculator to do quick, on-the-fly calculations

19 A simple and easy to use SQL editor to run queries and generate 
explain plans

20 A simple and easy to use PL/SQL editor to write and compile your 
PL/SQL code. Easily check the error messages and fix them.

21 Find database objects across all schemas

22 Export data from an existing table or a query in csv, tab delimited 
or user-defined delimited format. Export the data to Excel. Export the 
table data as insert statements.

23 Run individual SQL statements or run a script with multiple 
statements in the SQL Editor

24 Debug the PL/SQL code (future enhancement)

25 Open a new schema browser or SQL Editor by right-clicking on the 
button at the bottom of the screen

26 Open the window for an already established database connection by 
clicking on the appropriate button located at the bottom of the 
application.

27 Quickly check the system info of your local computer

28 Easily comment, uncomment text, change case (lower, upper, init 
cap), change background color, justify (center, left, right) text, wrap 
text, change font etc.

29 Text formatter to color code key words for easy readability

30 Execute stored procedures

31 Object browser window to quickly determine the tables available when 
writing stored procedures or SQL queries

32 Refresh the screen to get latest information about database objects

33 View DBMS output in the SQL Editor window

34 Change user password

35 View all invalid objects

36 View free space information for various database objects

37  View data linked by primary key and foreign key relationships

38  Multiple ways to connect to Oracle - OLEDB and ODBC.  Connect as 
SYSDBA or SYSOPER


-----------------------
FAQ
-------------------

Please visit http://www.impact-sol.com/faq.html
or 
contact info@impact-sol.com
