Can you please provide the detailed steps that one needs to take in order to upgrade an Oracle 10g Database (10.2.0.3 to 10.2.0.4) on Microsoft Windows Vista? If you have the patch numbers that one needs to download from Oracle's Metalink and the order that they need to be applied. Several users have pointed out that you cannot apply patches to a 10.2.0.3 database until it is upgraded to 10.2.0.4 and that interim patches require the Opatch utility. Any details would be appreciated!
Here you go
The patch No. is 6810189
Step 1). download the pacth from metalink. the file name for solaris is p6810189_10204_win32.zip
Step 2). Extract the file using unzip utilities p6810189_10204_win32.zip
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…