Author: Admin

Applies to: Oracle Server – Enterprise Edition – Version: 10.2.0.4 to 11.2.0.1 – Release: 10.2 to 11.2 Information in this document applies to any platform. Oracle Server Enterprise Edition – Version: 10.2.0.4 to 11.2.0.1 Goal 1.Do you still need to apply Patch Bundles for a certain patchset level when Patch Set Update (PSU) for that…

Read More “Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1” »

Applies to: Oracle Server – Enterprise Edition – Version: 8.1.7.4 to 11.2.0.2 – Release: 8.1.7 to 11.2 Oracle Server – Standard Edition – Version: 8.1.7.4 to 11.2.0.2 [Release: 8.1.7 to 11.2] Information in this document applies to any platform. Oracle Server Enterprise Edition – Version: 8.1.7.4 to 11.2.0.2 Purpose The purpose of this document is…

Read More “Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1” »

Applies to: Oracle Server – Enterprise Edition – Version: 10.2.0.1 to 11.1.0.7 Information in this document applies to any platform. Goal This article helps to plan oracle database patching sequence to the latest/required patchset version with in the same release (ex: 10.2.0.1 to 10.2.0.4) along with CPU/PSU/One-off-patch installations. Solution Basically there are two entities in…

Read More “Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1” »

Oracle Database (RDBMS) Releases Support Status Summary [ID 161818.1] Oracle Database (RDBMS) Releases Support Status Summary Information here was last updated on 14-Sep-2010 This note shows the current main Oracle Database releases along with information about the support status of each release and its Patch Sets. To see the main support alerts and Patch Set…

Read More “Oracle Support Metalink ID 161818.1” »

Oracle Learning Library ======================= http://apex.oracle.com/pls/apex/f?p=9830:41:0::NO Getting Started with Oracle SQL Developer ========================================= http://st-curriculum.oracle.com/obe/db/11g/r2/prod/appdev/sqldev/sqldev_mngdb/sqldev_mngdb_otn.htm Using Source Code Control in Oracle SQL Developer ================================================= http://st-curriculum.oracle.com/obe/db/11g/r2/prod/appdev/sqldev/srccodexmlext/srccode_otn.ht

grant update (colum1, col2) on owner.table_name to other_user/role;

There are 2 ways. 1) opatch lsinventory 2) select * from sys.registry$history;