Cmd How to delete a user instance from an Oracle database

Oracle database use process, for the system will establish a separate database users, but some time in the test or other reasons need to delete, the original DB users, then we can use the following method.

The premise of the subordinate operation is to ensure that the database service and monitoring are in the boot state.

1. Enter the DOS command window by entering CMD at the beginning.

2, enter sqlplus system/system password @ database name, click Enter, thereby connecting the database.

Example: Sqlplus pwlp_20180228/[email PROTECTED]:1521/ORCL

For example:

3. Enter select username from dba_users in the window above to display the user name in the current DB instance

4. Select the user to delete, enter in the current window: Drop user USERNAME cascade; Click Enter.

5, wait a moment, you can complete the database user delete action

Cmd How to delete a user instance from an Oracle database