How to delete user object in oracle

In Oracle, you can use the DROP statement to delete a specified user and all its objects. This statement is used to undo index, table and database operations. When used in conjunction with CASCADE, you can delete user objects. The syntax is " DROP USER usernameCASCADE".

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to delete user objects in oracle

When using Oracle database, you often encounter the need to re-import all objects of a user. Here are two commonly used methods for your convenience.

Deleting a user is actually the process of removing the user and the created database objects from the data dictionary.

DROP USER 用户名

If the user already has objects (such as TABLE, VIEW, etc.), do this:

DROP USER 用户名 CASCADE

But note: the connecting user cannot be deleted

1. Use drop user cascade; to delete the user and all related objects. You can re-create an object with the same name and then use imp Command to import new objects from dmp files.

2. Use the script to clear all the user's objects, including data tables, functions, stored procedures and other objects. Using this method, you don't need DBA permissions, which is very useful when you need to completely import a user's data.

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to delete user object in oracle. For more information, please follow other related articles on the PHP Chinese website!