Hello all..

I have a user who has created buch of tables/views/indexex/...etc. IS there acommand that will delete all his objects.

I know by using drop user cascade; will drop the user with tables....but here i want a similar command without dropping the user.

Thanks
Ron