Re: Rename schema

In article <8pbfja$1l2$1_at_ws41.cines.fr>,   "Gérard PIOCH" <gp_at_nospam.fr> wrote:
> Hi
> I have in my base a schema TOTO
> It has tables, indexes, synonyms which are attached to him. I would
 rename
> it in TITI by keeping him the set of its objects.
> Is there means to make it??
>
> Oracle 8.0.6 on server HP-UX 10.20
>
>

Yes export the user toto using owner=(toto) in the exp command drop user toto cascade
imp fromuser=(toto) touser=(titi), provided the user titi has been created first.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.