My conclusion: If Oracle doesn't provide the command, it is quite likely we should not be attempting it ourselves. Oracle says that the g (instead of the expected i) in the name symbolizes the companys commitment to the grid model. The problem is that we do not know when the userid (numeric) or the username (varchar2) is going to be used. (It may be as simple as "some idiot will want to rename SYS or SYSTEM and that will break the world.") Probably because THEY have not tested all variants to confirm that there is no impact. In version 10, Oracle has introduced Active Session History (ASH) and Automatic.
ORACLE 10G POSTER FREE
Unless you're doing your best to avoid the news, you've probably heard about the production release of Oracle Database 10 g Express Edition (XE), a free starter database for DBAs and. Oracle Real Application Cluster (RAC) is the Oracle cluster technology. So WHY does Oracle not provide a 'Rename User' command? After all, it has been asked officially (as a feature request) and unofficially (in forums, user groups, etc) many times over the years. Oracle Database XE's value is not necessarily limited to novices, students, hobbyists, or small businessesit also holds appeal for many other situations. And many of us have done it using the back door, apparently without impact.
It seems like a tremendously simple thing to do. Not sure why renaming a schema remains such a mystic activity that all wants to do it? Why did they not check the name when they were making it in the first place that it should be Jack not Jill :-(. I remember having the same question, I guess 2 years back, from a poster who posted the question and than the unsupported workaround even, only to be told that its going to hit him back really hard. 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.8K Oracle Database Express Edition (XE).3.7K Java and JavaScript in the Database On delle leghe r-smad garry winogrand poster hull, per fair 2014 rides jvc.