Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to TRUNCATE USER

Re: How to TRUNCATE USER

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 24 Jul 2002 23:29:23 +1000
Message-ID: <IRx%8.43135$Hj3.130296@newsfeeds.bigpond.com>


Hi Rick,

Although they often complain bitterly, cutting their legs off usually does the trick :)

Richard
"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:oojrjuoetm26s9e4ht469i38n0d95sbsij_at_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 Wed Jul 24 2002 - 08:29:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US