Online Documentation for SQL Manager for Oracle
|
Welcome to SQL Manager for Oracle! |
|
What's new |
|
|
System requirements |
|
|
Feature matrix |
|
|
Installation |
|
|
Registration |
|
|
How to register SQL Manager |
|
|
Version history |
|
|
FAQ |
|
|
Getting Started |
|
|
Selecting style and language |
|
|
First time started |
|
|
Using Desktop Panel |
|
|
Database navigation |
|
|
Working with database objects |
|
|
Using context menus |
|
|
DB Group context menu |
|
|
Database context menu |
|
|
Object context menu |
|
|
Working with windows |
|
|
Database Explorer |
|
|
Managing database registration info |
|
|
Connecting to databases |
|
|
Operations with database objects |
|
|
Selecting multiple objects |
|
|
Using tabs for database navigation |
|
|
Recently opened objects |
|
|
Managing Favorite objects |
|
|
Searching within the tree |
|
|
SQL Assistant |
|
|
Configuring Database Explorer |
|
|
Managing Favorite queries |
|
|
Database Management |
|
|
Create Database Wizard |
|
|
Specifying database name |
|
|
Specifying memory parameters |
|
|
Defining additional settings |
|
|
Defining database directories |
|
|
Data storage and redo log settings |
|
|
Creating database scripts |
|
|
Register Database Wizard |
|
|
Setting connection parameters |
|
|
Specifying tunneling parameters |
|
|
Selecting databases |
|
|
Setting specific options |
|
|
Database Registration Info |
|
|
Connection |
|
|
Options |
|
|
Display options |
|
|
Default directories |
|
|
Logs |
|
|
SSH tunneling options |
|
|
Data options |
|
|
Find option |
|
|
TNS Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Viewing file contents |
|
|
Database Registration Manager |
|
|
Using Navigation bar and Toolbar |
|
|
Database Objects |
|
|
New Object |
|
|
Duplicate Object Wizard |
|
|
Selecting the source database |
|
|
Selecting object to duplicate |
|
|
Selecting destination database |
|
|
Selecting table subobjects |
|
|
Modifying the new object's definition |
|
|
Schema objects |
|
|
Tables |
|
|
New table |
|
|
Using Navigation bar and Toolbar |
|
|
Setting table properties |
|
|
Specifying fields |
|
|
Specifying foreign keys |
|
|
Setting physical attributes |
|
|
Setting overflow attributes |
|
|
Partitioning |
|
|
Table Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Managing fields |
|
|
Managing keys |
|
|
Managing foreign keys |
|
|
Managing checks |
|
|
Managing indices |
|
|
Managing triggers |
|
|
Managing partitions |
|
|
Working with table data |
|
|
Table Properties |
|
|
Regular |
|
|
Global Temporary |
|
|
Clustered |
|
|
Index-organized |
|
|
External |
|
|
Record parameters |
|
|
Field parameters |
|
|
Blockchain |
|
|
Fields |
|
|
Field Editor |
|
|
Setting field name and type |
|
|
Setting autoincrement options |
|
|
Setting default value and comment |
|
|
Keys |
|
|
Key Editor |
|
|
Creating/editing key |
|
|
Storage options |
|
|
Setting key options |
|
|
Foreign Keys |
|
|
Foreign Key Editor |
|
|
Creating/editing foreign key |
|
|
Setting foreign key options |
|
|
Checks |
|
|
Check Editor |
|
|
Creating/editing check |
|
|
Setting check options |
|
|
Views |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing view |
|
|
Managing fields |
|
|
Managing keys |
|
|
Managing foreign keys |
|
|
Managing triggers |
|
|
Working with data |
|
|
Procedures |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing procedure |
|
|
Browsing procedure parameters |
|
|
Specifying input parameters |
|
|
Executing procedure/function |
|
|
Functions |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing function |
|
|
Browsing function parameters |
|
|
Triggers |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing trigger |
|
|
DB and Schema Triggers |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing DB/schema trigger |
|
|
Indexes |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing index |
|
|
Packages |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing package |
|
|
Package Bodies |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing package body |
|
|
Sequences |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing sequence |
|
|
Clusters |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing cluster |
|
|
Materialized Views |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing materialized view |
|
|
Managing fields |
|
|
Setting refresh parameters |
|
|
Setting USING INDEX parameters |
|
|
Working with data |
|
|
Partitioning |
|
|
Materialized View Logs |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing materialized view log |
|
|
Synonyms |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing synonym |
|
|
Database Links |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing database link |
|
|
Object Types |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing object type |
|
|
Object Type Bodies |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing object type body |
|
|
Array Types |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing array type |
|
|
Libraries |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing library |
|
|
Java Sources |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing Java source |
|
|
Java Classes |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing Java class |
|
|
Java Resources |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing Java resource |
|
|
Index Types |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing index type |
|
|
Operators |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing operator |
|
|
Adding operator binding |
|
|
Dimensions |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing dimension |
|
|
Adding dimension level |
|
|
Adding dimension hierarchy |
|
|
Queue |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing queue |
|
|
Adding Subscribers |
|
|
Schedules |
|
|
Queue Table |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing queue table |
|
|
Defining Physical Attributes |
|
|
Statistics |
|
|
Non-schema objects |
|
|
Contexts |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing context |
|
|
Profiles |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing profile |
|
|
Consumer Groups |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing consumer group |
|
|
Resource Plans |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing resource plan |
|
|
Directives options |
|
|
Directive comments |
|
|
Directories |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing directory |
|
|
Tablespaces |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing tablespace |
|
|
Managing files |
|
|
Managing objects |
|
|
Rollback Segments |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing rollback segment |
|
|
Redo Log Groups |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing redo log group |
|
|
Scheduler Schedules |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/Editing scheduler schedule |
|
|
Scheduler Programs |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/Editing scheduler program |
|
|
Scheduler Chains |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/Editing scheduler chain |
|
|
Scheduler Job Classes |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/Editing scheduler job class |
|
|
Scheduler Jobs |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/Editing scheduler job |
|
|
Scheduler Window Groups |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/Editing scheduler window group |
|
|
Scheduler Windows |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/Editing window |
|
|
Users and Roles |
|
|
Users |
|
|
User Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing user |
|
|
Tablespace parameters |
|
|
Setting quotas |
|
|
Proxy users |
|
|
Roles |
|
|
Role Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing role |
|
|
Query Management Tools |
|
|
Query data |
|
|
Using Navigation bar and Toolbar |
|
|
Working with Query Data |
|
|
Using the context menu |
|
|
Viewing query plan |
|
|
Using object links |
|
|
Executing queries |
|
|
Viewing query logs |
|
|
Using PL/SQL code debugger |
|
|
Favorites editor |
|
|
Design query |
|
|
Using Navigation bar and Toolbar |
|
|
Working with diagram area |
|
|
Joining two objects |
|
|
Setting criteria |
|
|
Setting output fields |
|
|
Setting grouping criteria |
|
|
Setting sorting parameters |
|
|
Working with the editor area |
|
|
Query execution |
|
|
Viewing query plan |
|
|
Query parameters |
|
|
Input parameters dialog |
|
|
Data Management |
|
|
Data View |
|
|
Using Navigation bar and Toolbars |
|
|
Grid View |
|
|
Customizing columns |
|
|
Grouping and sorting data |
|
|
Filtering records |
|
|
Using the context menu |
|
|
Working in multi-level mode |
|
|
Create Grid Level wizard |
|
|
Specifying master level |
|
|
Defining source for detail level |
|
|
Binding master and detail levels |
|
|
Query parameterization |
|
|
Setting additional parameters |
|
|
Working in card view mode |
|
|
Column Summary |
|
|
Copying records |
|
|
Form View |
|
|
Print Data |
|
|
Page Setup |
|
|
Page |
|
|
Margins |
|
|
Header/Footer |
|
|
Scaling |
|
|
Report Formatter |
|
|
View |
|
|
Behaviors |
|
|
Formatting |
|
|
Styles |
|
|
Preview |
|
|
Cards |
|
|
Charts |
|
|
Setting report options |
|
|
Print dialog |
|
|
BLOB View |
|
|
Navigation within BLOB Editor |
|
|
Editing as Hexadecimal |
|
|
Editing as Text |
|
|
Editing as Rich Text |
|
|
Editing as Image |
|
|
Editing as HTML |
|
|
Editing as XML |
|
|
Editing as PDF |
|
|
Applying changes |
|
|
Custom Filter |
|
|
Filter Builder dialog |
|
|
Invoking the Filter Builder dialog |
|
|
Adding a new condition |
|
|
Setting filter criteria |
|
|
Setting filter operator |
|
|
Setting filter criteria values |
|
|
Adding a new group |
|
|
Setting group operator |
|
|
Applying filter conditions |
|
|
Import/Export Tools |
|
|
Export Data Wizard |
|
|
Setting destination file name and format |
|
|
Selecting fields for export |
|
|
Adjusting data formats |
|
|
Setting header and footer |
|
|
Setting format-specific options |
|
|
Excel 97-2003 options |
|
|
Data format |
|
|
Fields |
|
|
Options |
|
|
Styles |
|
|
Extensions |
|
|
Hyperlinks |
|
|
Notes |
|
|
Charts |
|
|
Cells |
|
|
Merged Cells |
|
|
Advanced |
|
|
Access options |
|
|
Word / RTF options |
|
|
Base Styles |
|
|
Strip Styles |
|
|
HTML options |
|
|
Preview |
|
|
Basic |
|
|
Multi-file |
|
|
Advanced |
|
|
PDF options |
|
|
TXT options |
|
|
CSV options |
|
|
XML options |
|
|
MS Excel / ODS options |
|
|
MS Word / ODT options |
|
|
Setting common export options |
|
|
Exporting data |
|
|
Import Data Wizard |
|
|
Selecting source file name and format |
|
|
Selecting data source |
|
|
Setting fields correspondence |
|
|
Excel 97-2003 |
|
|
Access |
|
|
DBF |
|
|
XML Datapacket |
|
|
TXT |
|
|
CSV |
|
|
HTML |
|
|
XML Generic |
|
|
MS Excel/Word, ODF |
|
|
Adjusting data formats |
|
|
Setting advanced field formats |
|
|
Setting import mode |
|
|
Customizing common options |
|
|
Importing data |
|
|
Export as SQL Script |
|
|
Selecting destination DBMS |
|
|
Setting destination file name |
|
|
Setting BLOB options |
|
|
Selecting fields to export |
|
|
Editing table definition |
|
|
Setting export options |
|
|
Exporting as SQL Script |
|
|
Database Tools |
|
|
SQL Monitor |
|
|
Using Navigation bar and Toolbar |
|
|
Working with SQL Monitor |
|
|
Execute script editor |
|
|
Using Navigation bar and Toolbar |
|
|
Working with SQL Script editor area |
|
|
Using Script Explorer |
|
|
Script execution |
|
|
Oracle Client Checker |
|
|
Search in Metadata |
|
|
Extract Database Wizard |
|
|
Selecting source database |
|
|
Specifying destination file name |
|
|
Setting extraction mode |
|
|
Setting BLOB options |
|
|
Selecting objects for structure extraction |
|
|
Selecting objects for data extraction |
|
|
Customizing script options |
|
|
Start of extraction process |
|
|
Compare Databases Wizard |
|
|
Selecting source database |
|
|
Selecting schemas of the source database |
|
|
Selecting target database |
|
|
Selecting schemas of the target database |
|
|
Selecting type of the synchronization script |
|
|
Defining options for destination script |
|
|
Performing operation |
|
|
Print Metadata |
|
|
Using Navigation bar and Toolbar |
|
|
Selecting objects |
|
|
Printing options |
|
|
HTML Report Wizard |
|
|
Selecting database and directory |
|
|
Selecting object types |
|
|
Selecting schemas |
|
|
Specifying CSS |
|
|
Setting additional report options |
|
|
Creating HTML report |
|
|
Reports management |
|
|
Create Report Wizard |
|
|
Specifying database name and report options |
|
|
Selecting report bands |
|
|
Selecting report style |
|
|
Specifying page settings |
|
|
Specifying paper settings |
|
|
Specifying margins |
|
|
Specifying other page settings |
|
|
Report Designer |
|
|
Adding dialog form |
|
|
Adding database and query components |
|
|
Adding report data |
|
|
Viewing the report |
|
|
Saving the report |
|
|
Report Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Viewing Report |
|
|
Report Viewer |
|
|
Using Toolbar and context menu |
|
|
Working with Report Viewer |
|
|
Page settings |
|
|
Exporting report content |
|
|
Sending by E-mail |
|
|
Dependency Tree |
|
|
Using Navigation bar and Toolbar |
|
|
Viewing dependency tree |
|
|
Instance Manager |
|
|
Using Navigation and Toolbar Bar |
|
|
Service Status |
|
|
Configuring Service |
|
|
Grant Manager |
|
|
Using Navigation bar, Toolbar and context menu |
|
|
Setting object grants |
|
|
Managing database-specific privileges |
|
|
Managing column permissions |
|
|
Filtering objects in list |
|
|
Managing system privileges |
|
|
Managing roles |
|
|
Visual Database Designer |
|
|
Using Navigation bar and Toolbars |
|
|
Using Diagram Navigator and DB Objects pane |
|
|
Using context menus |
|
|
Working with diagram objects |
|
|
Adding/removing objects to/from diagram |
|
|
Incremental search |
|
|
Creating objects |
|
|
Creating relations |
|
|
Working with diagram pages |
|
|
Reverse engineering |
|
|
Printing diagram |
|
|
Print Preview |
|
|
Print Setup dialog |
|
|
Saving/loading diagram |
|
|
Setting diagram options |
|
|
Services |
|
|
Database Information |
|
|
Common Parameters |
|
|
Instance Parameters |
|
|
Extended Parameters |
|
|
Database Statistics |
|
|
Using Navigation bar and Toolbar |
|
|
System Statistics |
|
|
Last Analyze Stats |
|
|
Sessions |
|
|
Hit Ratios |
|
|
Process |
|
|
Locks |
|
|
Storage |
|
|
Tablespace |
|
|
Control Files |
|
|
Data Files |
|
|
RBS Activity |
|
|
Redo Switch Frequency |
|
|
SGA |
|
|
Summary SGA |
|
|
Library Cache |
|
|
Data Dictionary Cache |
|
|
Wait Events |
|
|
Latches |
|
|
Database Alerts |
|
|
PL/SQL Profiler |
|
|
Using Navigation bar and Toolbar |
|
|
Using PL/SQL Profiler |
|
|
Advanced Statistics Wizard |
|
|
Selecting database and stats mode |
|
|
Selecting objects |
|
|
Specifying additional settings |
|
|
Managing statistics |
|
|
TKProf Wizard |
|
|
Defining common settings |
|
|
Selecting input files |
|
|
Setting sorting options |
|
|
Defining execution plan |
|
|
Specifying additional options |
|
|
Backup Database |
|
|
Selecting database and backup strategy |
|
|
Checking database and instance settings |
|
|
User-managed script |
|
|
Selecting datafiles |
|
|
Setting additional options |
|
|
Recovery Manager (RMAN) |
|
|
Specifying backup type and options |
|
|
Setting additional options |
|
|
Scheduling backup scripts |
|
|
Running database backup operation |
|
|
Restore Database |
|
|
Selecting database and restore strategy |
|
|
User-managed script |
|
|
Verifying current settings |
|
|
Selecting datafiles |
|
|
Setting additional options |
|
|
Recovery Manager (RMAN) |
|
|
Setting additional options |
|
|
Running database restore operation |
|
|
Flashback |
|
|
Specifying the source database and selecting the operation |
|
|
Selecting the table to flashback |
|
|
Specifying flashback settings |
|
|
Previewing the data in the selected flashback point |
|
|
Running flashback operation |
|
|
Job Manager |
|
|
Using Navigation bar and Toolbar |
|
|
Managing jobs |
|
|
Job Editor |
|
|
Truncate Wizard |
|
|
Selecting database and object type |
|
|
Selecting objects |
|
|
Setting truncate options |
|
|
Recompile Invalid Objects |
|
|
Using Navigation bar and Toolbar |
|
|
Working with recompile service |
|
|
Enable/Disable constraints |
|
|
Selecting database |
|
|
Selecting schema and tables |
|
|
Specifying operation and target |
|
|
Options |
|
|
Environment Options |
|
|
Preferences |
|
|
Full mode activation |
|
|
Confirmations |
|
|
Appearance |
|
|
Tools |
|
|
DB Explorer |
|
|
Search |
|
|
Object Editors |
|
|
Query data |
|
|
SQL Monitor |
|
|
Database Alerts |
|
|
Execute Script |
|
|
Design Query |
|
|
Style & Color Palette |
|
|
Visual Database Designer |
|
|
Print Metadata |
|
|
Data Export |
|
|
Fonts |
|
|
Grid |
|
|
Data Options |
|
|
Print Data |
|
|
Color & Formats |
|
|
Advanced |
|
|
Column Options |
|
|
Localization |
|
|
Global Shortcuts |
|
|
Find Option |
|
|
Editor Options |
|
|
General |
|
|
Display |
|
|
Color Scheme |
|
|
Code Completion |
|
|
SQL Formatter |
|
|
SQL Words |
|
|
Key Mapping |
|
|
Spell Checking |
|
|
Find Option |
|
|
Save Settings |
|
|
Specifying destination file |
|
|
Selecting settings |
|
|
Selecting databases |
|
|
Saving settings |
|
|
Localization |
|
|
Localization Editor |
|
|
Select Program Language |
|
|
Keyboard Templates |
|
|
Object Templates |
|
|
Find Option dialog |
|
|
How to... |
|
|
Work with Databases |
|
|
Connect to a database |
|
|
Edit database connection parameters |
|
|
Make work with a database faster |
|
|
Design a visual database structure |
|
|
View an ER diagram |
|
|
Backup a database |
|
|
Restore a database from backup |
|
|
Create a database copy |
|
|
Document a database |
|
|
Save metadata reports to file |
|
|
Log database changes |
|
|
Get an SQL dump |
|
|
Synchronize two databases |
|
|
Work with Database Objects |
|
|
Group objects |
|
|
Find objects |
|
|
View dependecies |
|
|
Get an object DDL |
|
|
Work with Data |
|
|
View tables with many records |
|
|
Set data filter |
|
|
Sort and group data |
|
|
Export/import data |
|
|
Export data as SQL script |
|
|
Export filtered data |
|
|
Edit data of master-detail tables |
|
|
Create an autoincrement field |
|
|
Add image to table |
|
|
Set data display format |
|
|
Work with Queries and Scripts |
|
|
Create SQL statements rapidly |
|
|
Control query productivity |
|
|
Work with several queries at once |
|
|
Save most frequently used queries |
|
|
Execute queries with parameters |
|
|
Export query results into file |
|
|
Execute scripts |
|
|
Execute a large SQL script |
|
|
Make SQL script work faster |
|
|
Customize work with Query/Script text |
|
|
View executed queries and scripts |
|
|
Debug procedures |
|
|
Create a simple report in Report Designer |
|
|
Transfer program settings |
|
|
Update SQL Manager |
|
|
Report bugs and suggestions |
|
|
Appendix |
|
|
Advanced connection settings |
|
|
Program interface |
|
|
Viewing object DDL structure |
|
|
Editing object description |
|
|
Browsing object dependencies |
|
|
Setting object permissions |
|
|
Setting program roles |
|
|
Adding restore point |
|
|
Changing Metadata window |
|
|
Find Text dialog |
|
|
Replace Text dialog |
|
|
Format specifiers |
|
|
Language Info Editor |
|
|
Using templates |
|
|
Supported file formats |
|
|
To-Do List |
|
|
Window List |
|
|
Customize toolbars and menus |
|
|
SSH tunneling options |
|
|
SQL Manager Direct |
|
|
Database Login dialog |
|
|
Overwriting existing output file |
|
|
Script conversion |
|
|
Storage attributes |
|
|
Select Object dialog |
|
|
SQL Manager shortcuts |
