Force removal of the Oracle user being connected to remove the SDE user as an example

。

Sometimes you want to force the deletion of an already connected Oracle user, cannot be deleted directly, can use kill session information.

For example, to delete a connected SDE user today, you can delete a "connecting" user in the following ways.

1. View the session information for all users.

Select Sid,serial#,username from V$session;

2. View the session information for a specified user.

For example, if we want to delete the SDE user, you can use the following command to view the SDE user's session information.

Select sid,serial# from v$session where username= ' SDE ';

We get the SDE user's _sid and _serial# from the above command, preparing for the following kill command.

As in, we get the user SDE's session information in the SID of 12,serial# to 235.

3. Execute the KILL command

Alter system kill session '_sid, _serial# ';

Where the _sid and _serial# specific values are the values that are queried in step 2nd.

Alter system kill session ' 12,235 ';

4. Delete the user SDE.

The command is: Drop user SDE cascade.

Force removal of the Oracle user being connected to remove the SDE user as an example