From the mouth of Oracle themselves:

No, this is listed as Enhancement Request 158508.
Workaround:
Do a user-level export of user A
create new user B
import system/<password> fromuser=A touser=B
drop user A

***********************************

Now there's a little more to it than that, but basically that's it.

That said, what you can do is create a new tablespace like the old one,
do a 'create like' of the old user (A) to the new user (B), and THEN do
the export /import fromuser A touser B.

NOW drop user A, followed by some of the usual clean up to keep your
server guys happy.


Jeffrey C. Ferrel
DMS III
State of Nevada
775.687.9327
[Email address protected]


-----Original Message-----
From: Geerlings Mark
[mailto:oracledba-ezmlmshield-x94867152.[Email address protected]
Sent: Tuesday, February 27, 2007 1:05 PM
To: LazyDBA Discussion
Subject: RE: In a 10g database, can you rename a user(schema)?

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.




---------------------------------------------------------------------
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



Oracle LazyDBA home page