Re: ORACLE user names and tables

The only way to delete a user in Oracle is to do a full database export and import once you have revoked all their access rights. Also, you need to write yourself a SQL from SQL script that generates drop table statements for all the tables & other objects owned by the user.

In my opinion, it's a shame Oracle don't supply a library of such scripts seeing as DB admin relies on them so much.

                                Richard

-- 
Richard Thombs					      Lucas Powertrain Systems,
Mail:  rst_at_eg.lucasauto.co.uk			      Phoenix Way,
Phone: +44 285 657981 x233			      Cirencester, GL7 1QG,
Fax:   +44 285 658258 (G3)			      England.