RE: Renaming schemas directly

One can use your method if you like, but don't tell OTS about it.
They have a habit of starting to have a good laugh as they tell you to
export and rebuild the database. Messing around in the lower levels of
the data dictionary is something that should be done at the direction of
OTS only and then with extreme care. OH and yes only after a full cold
backup.

It would sure be swell if Oracle gave us some means to rename schemas,
but, they don't. I'm in 10g, and going behind the scenes, I can rename
a schema, once, but I can't seem to rename it back again. Here's the
deal-i-o...