From: "Guus van de Sande" <gs.dyntas@wxs.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: Rename schema
Date: Sat, 9 Sep 2000 11:53:12 +0200
Organization: Planet Internet
Lines: 12
Message-ID: <8pd1av$9he74$1@reader4.wxs.nl>
References: <8pbfja$1l2$1@ws41.cines.fr>
NNTP-Posting-Host: ipc37970e5.dial.wxs.nl
X-Trace: reader4.wxs.nl 968493215 10008804 195.121.112.229 (9 Sep 2000 09:53:35 GMT)
X-Complaints-To: abuse@wxs.nl
NNTP-Posting-Date: 9 Sep 2000 09:53:35 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600


As far as I know, the only way to achieve that is:

export all objects from user TOTO.
create a user TITI
import  fromuser=TOTO  touser= TITI
delete user TOTO.

good luck,
Guus van de Sande