Online Documentation for SQL Manager for Oracle

Database Management


SQL Manager for Oracle provides a number of tools you may need to manage your Oracle databases.

Find the list of common database management operations for working in SQL Manager below.

 

 

Registering Databases

  • select the Database | Register Database... main menu item or use the corresponding btnRegisterDB Register Database toolbar button

or

  • right-click an existing database or database group alias and select the Register Database... context menu item in the DB Explorer tree;
  • set all the necessary options using Register Database wizard which guides you through the entire process of Database registration.

 

Unregistering Databases and Database Groups

  • select the database (or the database group) to unregister in the DB Explorer tree;
  • select the Database | Unregister Database (or Database | Unregister Database Group) main menu item or use the corresponding btnUnregisterDB Unregister Database toolbar button

or

  • right-click the database (or the database group) alias and select the Unregister Database (or Unregister Database Group) context menu item in the DB Explorer tree;
  • confirm unregistering in the corresponding dialog window.

 

Creating Databases

  • select the Database | Create Database... main menu item or use the corresponding Create Database btnCreateDB toolbar button

or

  • right-click an existing database or database group alias and select the Create Database... context menu item in the DB Explorer tree;
  • set all the necessary options using Create Database wizard which guides you through the entire process of Database creation.

 

Connecting to Databases

  • select the database to connect to in the DB Explorer tree;
  • select the Database | Connect to Database main menu item or use the corresponding btnConnectToDB Connect to Database toolbar button

or

 

Disconnecting from Databases

  • select the database to disconnect from in the DB Explorer tree;
  • select the Database | Disconnect from Database main menu item or use the corresponding btnDisconnectFromDB Disconnect from Database toolbar button

or

  • right-click the database alias and select the Disconnect from Database context menu item in the DB Explorer tree.

 

Viewing and Editing Database Registration Info

  • select the database or any of its objects in the DB Explorer tree;
  • select the Database | Database Registration Info... main menu item

or

  • right-click the database alias or any of its objects and select the btnDBRegInfo Database Registration Info... context menu item in the DB Explorer tree.

 

Viewing and editing TNS file

  • right-click the database or database group alias and select the TNS Editor context menu item;
  • use the TNS Editor to view/edit local naming parameters.