No, that is not supported in Oracle. If you have a test system that you
don't mind corrupting, you could try an update of the row in SYS.USER$
for that schema, then a database shutdown and restart or at least a
"flush shared pool". If you are lucky, that may work, but if it was
really that easy, Oracle would probably support it.

-----Original Message-----
From: (Bill Lusk)
[mailto:oracledba-ezmlmshield-x35369220.[Email address protected]
Sent: Tuesday, February 27, 2007 4:00 PM
To: LazyDBA Discussion
Subject: In a 10g database, can you rename a user(schema)?

Can a schema be renamed in an Oracle 10g database? And if so, what is
the command?


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.



Oracle LazyDBA home page