delete all tables belonging to a user.

[GERPAT]

Does anyone know hou do delete all tables belonging to a user. I tried the following but it doesn't work:

delete from username.*

 

[carp]

If you aren't in the process of deleting the user, then you might want to write a script:

SELECT 'DROP TABLE the_user_name.'||table_name||';'
FROM dba_tables
WHERE user_name = 'THE_USER_NAME';

 

[did02]

Another way to do this is to drop the user and then recreate it. But it drop all its objects (view,...)

Rgds,
Did02