It seems that my first blog post today "ALTER USER RENAME - A half official option
" got some great attentions :-)
How did I come to the ALTER USER RENAME command? Just a lucky punch due to my customer. My customer were trying to rename an user in an Oracle Database with several objects (tables, view, functions, types and so) by simply updating the sys.user$ table :-)
The result were better than (more...)
Many times DBA's have to rename / copy complete users/schemas from the current name to a new name within one database. Since several years DBA's are asking for a simple method inside Oracle to execute something like "ALTER USER RENAME".
Common approaches to rename users/schemas are:
- IMPDP with REMAP_SCHEMA
- update of sys.user$
For the option "update of sys.user$", which is in my opinion a really bad choice, see Tom Kyte's comment
Since 19th January 2016 the Critical Patch Update for January 2016 is out.
In case you are trying to apply the CPUJan2016 against an Oracle WebLogic Server 12.1.2 you may run into following error:
Verifying the update...
[ Error during Update inventory for apply Phase]. Detail:
There are 1 copy files under ORACLE_HOME that are not patched.
Files check failed: Some files under ORACLE_HOME are not patched.
Please see logfile for details.
As everybody already know that the latest version of Oracle Enterprise Manager 13c (220.127.116.11) has been released yesterday (see also my post from 18th December 2015
), Oracle has uploaded several interesting presentations around the new Oracle Enterprise Manager 13c.
The presentations are covering various topics around the Oracle Enterprise Manager 13c (some presentations are also still covering Enterprise Manager 12c):
- Cloud Management
- Middleware Management
- Database Management
- Installation & Upgrade | (more...)
Seems its early Christmas :-) the new release of the Oracle Enterprise Manager 13c (18.104.22.168) is available for download in the Oracle Technology Network http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html
The new Oracle Enterprise Manager 13c is available for:
- Linux x86-64
- Windows x86-64
- Solaris (SPARC)
- Solaris (x86-64)
- IBM AIX on POWER Systems
- HP-UX Itanium
Happy download :-)