Re: change oracle schema name

"Mark" <mbwn_at_inwind.it> wrote in message news:ZP8D8.44793$US3.978644_at_twister1.libero.it...
> Is it a way, or a dirty trick to change the name of an oracle user
schema,
> without
> dropping and creating its objects?
>
> regards
> Mark
>
>

The trick is called export the schema, import it into a different user. Other 'solutions'

- are for the lazy
- will screw up the dictionary
- will invalidate your support contract.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address