EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

Libraries


A Library is a schema object associated with an operating system shared library.

 

 

Creating Libraries

 

To create a new library:

Hint: To create a new library, you can also right-click the Libraries node or any object within this node in the DB Explorer tree and select the New Library item from the context menu.

 

To create a new library with the same properties as one of existing libraries has:

Alternatively, you can right-click a library in the DB Explorer tree and select the Duplicate Library <library_name>... context menu item.

 

Duplicate Object Wizard allows you to select the database to create a new library in, and to edit the result SQL statement for creating the library.

 

 

Editing Libraries

 

To edit an existing library:

  • select the library for editing in the DB Explorer tree (type the first letters of the library name for quick search);
  • right-click the object and select the Edit Library <library_name> context menu item, or simply double-click the library;
  • edit library properties using the appropriate tabs of Library Editor.

 

Dropping Libraries

 

To drop a library:

  • select the library to drop in the DB Explorer tree;
  • right-click the object and select the Drop Library <library_name>... context menu item;
  • confirm dropping in the dialog window.

 

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new library;

Ctrl+O to edit the selected library;

Shift+Del to drop the object from the database.