DROPPING v7.0.x USERS

From: <ucdy_at_rvax.syntex.com>
Date: 5 Oct 1994 21:04:18 GMT
Message-ID: <36v4ci$24u_at_yoda.Syntex.Com>


Does anybody know how to reduce the time required for  

        DROP USER <user> CASCADE;

statements to execute? We have tried dropping all user objects and grants before issuing the drop command, but it doesn't seem to make much difference.

Currently it takes anywhere from 6 to 30 minutes to drop users.

Any info appreciated.

Chas. Dye Received on Wed Oct 05 1994 - 22:04:18 CET

Original text of this message