Online Documentation for SQL Management Studio for Oracle

Using Desktop Panel


Desktop Panel is the main working area of SQL Management Studio for Oracle. The content of the Desktop Panel scratch changes dynamically according to the current selection in the Navigation bar of the main toolbar.

 

Getting Started - Desktop Panel

 

Using the Desktop Panel items you can:

 

DBManagement launch the all-in Database management program (SQL Manager for Oracle) and run basic Oracle services:

  • Backup Database (with or without a template);
  • Restore Database (with or without a template);
  • Database Statistics (with or without a template);

 

DataManipulation launch integrated Data manipulation utilities:

  • Data Export for Oracle (with or without a template, GUI or console version);
  • Data Import for Oracle (with or without a template, GUI or console version);
  • Data Pump for Oracle (with or without a template, GUI or console version);
  • Data Generator for Oracle (with or without a template, GUI or console version);
  • SQL Script for Oracle (with or without a template, GUI or console version);

 

DataAnalysis launch utilities implemented for Data analysis:

  • Data Comparer for Oracle (with or without a template, GUI or console version);
  • DB Comparer for Oracle (with or without a project file, GUI or console version);
  • DB Extract for Oracle (with or without a template, GUI or console version);
  • SQL Query for Oracle;

 

TemplateManagement manage templates for each of the integrated tools and services;

 

CustomTasks manage miscellaneous tasks;

 

TaskScheduler manage scheduled tasks;

 

Logs manage task logs;

 

InternetResources use available Internet resources:

  • visit SQL Studio Home Page;
  • browse SQL Studio pages dedicated to Frequently Asked Questions;
  • browse online documentation concerning SQL Studio components;
  • visit Oracle related resources;

 

StudioDirect use the SQL Studio Direct feature;

 

Support get technical support online.

 

Hint: To activate/deactivate brief descriptions displayed for each tool on the Desktop Panel, you can use the View | Show Tool Descriptions item of the main menu.