Modify PL/SQL Developer connection information

Login tool PL/SQL Developer

Execute the command

DROP USERUser_name (user name) CASCADE;Copy the code

Such as:

DROP USER CAPITAL2018 CASCADE;
Copy the code

Summary: In Oracle, how do I delete all data from a user?

2, DROP USER user_name CASCADE; 3, DROP USER user_name CASCADE; Note: then the user including the tables under the user, attempts, synonyms, procedures, indexes, and all related are deleted. 3. Then create a new user with the same name and grant corresponding permissions.Copy the code