Designed to aid the database administrator or programmer with the management of Oracle through the extraction, generation, and manipulation of SQL scripts, DataBase Assistant will get you home at night. No longer will you spend your time checking to see if your source still matches you developmental instance before you move it to production. View the space remaining in a tablespace and correct the problem, before you run out. No more searching for your SQL code only to find out you deleted it yesterday. DataBase Assistant can get all of that for you and more, straight from Oracle catalogs so you know it is current, and it does this all while running under Microsoft's Windows, Windows 95, Windows NT, or even IBM's OS/2 in a windows box.
Features like find, replace, cut, copy, and paste ease the development and maintenance of your SQL code. Multiple editors allow concurrent editing of several scripts. You can even run the scripts directly from the editor, the editor has a 32,000 character limit which holds the longest SQL statements Oracle allows.
Pop-up dialog boxes generate any Data Definition Language "DDL" or Data Control Language "DCL" statement used to maintain your databases. You can create, alter, or drop any object directly from DataBase Assistant. You also have the ability to generate this code without executing is at the current time, keeping it for use later in the same or in another instance.
DataBase Assistant can extract the DDL from the Oracle catalog for any object in the database. DataBase Assistant will also allow you to optionally extract any and all related objects, along with all of the DCL or grants to these objects. No longer will you have to find out which objects are in a tablespace, you simply extract the tablespace with all of the objects contained in it. No longer will you have to Search out all of the objects a user owns, you simply select the user, and extract all of the user objects.
DataBase Assistant can display the Storage Utilization, Tablespace Fragmentation, Row Caching, Directory Caching, SGA size, Initialization Parameters, and even the current users along with the current function they are performing. You can view information on any object without extracting it. You can work on multiple instances at the same time regardless of whether they are Version 6 or Version 7.
When you register, send your email address along with $99.95 US + $10 US, shipping and handling, and we will send you a registered copy of DataBase Assistant, plus a full users Manual. You will also be registered to receive notification about future upgrades and enhancements! Visit our registration page for our address and more information. A registration form will be included in your download file.
Download DataBase
Assistant NOW!