Abilities of the SQLaps
SQL Assistant for Oracle:
1) Supports the Oracle Server 翻译 - 8i/10g and 9i support HAS BEEN ADDED!
2) SQL Editor allows execute SQL statements in the separated threads (parallel execution of the long-time queries), PL and scripts/SQL blocks,preview the explain plan, export data to SQL and text*Loader control files, use the code queries and completion history for
quick return to the earlier executed statements.
3) Extract DDL Wizard allows to extract schema generate and objects SQL script for these objects.
4) Management of the Schemas,Functions,Procedures,Packages,partitioned and simple Tables,Indexes,Constraints,Views,
Triggers.
5) 安全 management (management and Creating profiles and roles, revokes and grant privileges.
management and Creating the users accounts, the recompile and checking the invalid objects).
6) Sessions management, SQL monitoring, start/stop sessions tracing, and show results.
7) Management of the Tablespaces and Redologs. (checking and Creating redogroups,redologs files, management tablespaces,
resizing and management datafiles)
8) Improved, fast and useful interface for the Oracle Logminer (view/run stored statements for the executed
transactions (redo- and archivelogs)), no additional installations require. (fast and Simple analyze of the redo/archivelogs).
9) Preview/save the images into the BLOB/CLOB fields from clipboard.
You can 下载 15-days trial 翻译 of S.
Q.
Lap's SQL Assistant from links at
http://sqlap.fortunecity.com/
You can find the detail description of application in the users manual (sqlapmanual.doc in the ZIP-archive). Latest 翻译 has improvement DBExplorer, Extract Wizard, allows 处理 FK-ref tables etc.
Please write your questions, all and suggestions contacts to sqlapsqlassistant@yahoo.com
Thanks,
The SQLap's SQL Assistant
Developers team.