How to delete oracle user

In Oracle, you can use the drop command to delete users. This command can delete specified data. This command can be used with the cascade keyword to delete users. The syntax is "drop user username cascade;".

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

How to delete oracle user

sqlplus login

sqlplus sys/isc@testgmmc as sysdba

Create user

create user testpoi3 IDENTIFIED by isc
account unlock;
grant dba,advisor to testpoi2;

Delete user

drop user djcfw cascade;

Data export

exp testwms2/isc@test-193 OWNER=testwms2 FILE=D:\temp\testwms2.dmp
exp testapar/isc@hs OWNER=testapar FILE=D:\testwms2.dmp TABLES=DEPT

Examples are as follows:

Recommended tutorial: "Oracle Video Tutorial"

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