EMS logo

Produkt Navigation

SQL Manager for Oracle

Unsere Partnerschaften

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

Online Bedienungsanleitung

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.

 


See also:

Getting Started

Database Explorer

Database Objects Management

Query Management Tools

Data Management

Import/Export Tools

Database Tools

Services

Options

How To...