Smart Datasys
Customize your way...
Oracle Features

Standard Features (Oracle)

Cross-Platform Database support
Key Press Search Functionality
Connect upto 5 Datasource and unlimited databases
Secured as password are stored in Encripted format
Controlled as only installer can start program
SQL Editor to execute SQL/PL SQL Queries
Save SQL Result in Delimited,xls,HTML format
Browse Schema objects like
* Check Constraints
* Database Link
* Foreign Key Constraints
* Functions
* Indexes
* Invalid Objects
* Java Source
* Materialized Views
* Packages
* Package Body
* Primary Key Constraints
* Procedures
* Sequence
* Synonyms
* Tables
* Triggers
* Type
* Type Body
* Unique Key Constraints
* Views
option to browse by individual owner
Browse Data Devices
Browse Dump/Tape Devices
Browse Logins
Instance Configuration Details
Instance Details
SGA
Security (Users and Roles)
Storage
* Control Files
* Data Files
* Redo Log Files
* Rollback Segments
* Tablespaces

Find Column in Tables
Process Monitor to Monitor Server Activities
Automatically Save and Recall Executed Queries
Conditional Replace based on IF THEN ELSE
Compare Unix Diff Files and text files
Helpdb - Tablespace Space Usage with auto refresh


ConfigDiff - Compare Server Configuration Parameters useful for DR Servers

DBAdmin - Easily Create/Drop/Alter/Replicate
* Tablespaces
* DBLinks
* Databse Files
* Roles
* Users
* Grant / Revoke
** Object Permissions
** System Permissions
* Monitor various Ratios
* Compare schemas

Schema Extraction
Create - Generates syntax which was used while creation
Drop - Generates syntax to drop one/all objects
Grant - Generates syntax to grant permissions
Revoke - Generates syntax to revoke permissions
Compare - Compares Object counts between two Servers/Databases
Compare DDL - Compares DDLs between two Servers/Databases

SaveIndividual - Saves DDLs to individual files which are helpful to manage Source Code Control System.
Object Types
* Check Constraints
* Comments
* Database
* Database Links
* Foreign Key Constraints
* Functions
* Indexs
* Materialized Views
* Packages
* Package Body
* Primary Key Constraints
* Procedure
* Sequence
* Synonyms
* Tables
* Tablespaces
* Triggers
* Type
* Unique Key Constraints
* Users
* Views

Automate Exoprt/Import
Export - All Tables or Single Table
Import - All Tables or Single Table
Suffix Database Files with predefined Format like DD,DDMM,DDMMYYHH,HHMin etc.
Saves Export/Import History

Smart Universe - Build Query Universe
* Add Executed query to the universe
* Assign Column level parameters as filter
* Get Query from Universe directly into SQL Editor


SQL Builder
- Generate Select Query
* Join up to 4 tables
* Automatically generate where conditions based on the matching field names.


Migration
- Cross-platform data transfer
* Transfer table data from Oracle To Sybase,Oracle,SQL Server
 

 


 

 

Oracle Features
HomeCompanyProductsBuyDownloadServicesNonVisibleContact UsRegistration