Originally posted by sh_sonu
The user object should remain after the dropping of all the objects owned by it.
You mean to say.. you need to cleanup the USER. and DON't want to DROP USER (SCHEMA) (USER=SCHEMA)

1. connect to the USER whos objects you want to drop.
2. spool output of following sql

SELECT 'DROP '||object_type||' '||object_name ||';' FROM user_objects

3. and execute statements generated by spool file.

You may get some errors while dropping objects having dependancies.. that u have to take care..

HTH

Sameer

[Edited by Sameer on 08-26-2002 at 04:30 AM]