Oracle deletes all tables of a user.

Some people said that they would first delete a user and then create the user.

I want to delete all tables under this user, but do not delete others.

1. query all tables under this user:

Executed under this user (no result, because it should not be fromDba_all_tablesQuery this table ):

Select * From dba_all_tables t where T. Owner = 'user ';

The correct one should be like this:

Select * fromAll_tablesT where T. Owner ='Ydsoft _ base';

In the single quotes'Ydsoft _ base' must be capitalized. Otherwise, no results can be found.

Then, I manually delete