Dropping or removing an object

Use the Confirmation window to confirm that you want to drop or remove the objects selected in the box.

Removing a cataloged object (such as, a database or instance) uncatalogs it.

Dropping an object deletes its contents and, if it is a cataloged object, uncatalogs it.

Any objects that are directly or indirectly dependent on an object you drop or remove are either deleted or become inaccessible, and all references to them are invalidated.

Fields and controls

Authorities and privileges



To drop or remove an object:

  1. Select one or more objects and choose Drop or Remove from the pop-up menu.

  2. Optional: If you do not want to drop or remove an object that is listed in the box, clear the check box to the left of the object's name.

  3. To drop or remove all of the objects selected in the box, click on OK. Any unselected objects are left untouched.

  4. Optional: To cancel the entire operation and close the confirmation window, click on Cancel.