How to TRUNCATE USER

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Tue, 23 Jul 2002 23:56:35 +0200
Message-ID: <oojrjuoetm26s9e4ht469i38n0d95sbsij@4ax.com>

Hello

This is simple: Preparing a DB for import. I know about IGNORE=Y but I would prefer a clean state to begin with. I could also drop the user whose schema I want to get rid of before importing, but this is prone to errors since I would need to recreate all his properties (privileges, roles etc.). Finally, I could drop all his objects, hundreds of them... rather not.

So how can I truncate users, meaning getting rid of all his data in order to reimport again?

Thanks
Rick Received on Tue Jul 23 2002 - 16:56:35 CDT