| Virusminus |
Posted: Apr 23, 2008 09:47:16 AM |
Total Post: 14
Joined: Jan, 2008
|
Hi Friends,
I need to upgrade an Oracle database in windows OS from 8.1.7 to 10G. Could anyone please give me the procedure for this. Thanks. |
|
|
 Murtuja |
| Posted: Apr 23, 2008 10:36:07 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
Hi,
You have to download patch from metalink and you have to follow readme
file from this patch.
|
|
|
|
|
| Virusminus |
| Posted: Apr 23, 2008 11:06:06 AM | |
|
Total Post: 14
Joined: Jan, 2008
|
Could you please tell me which patch I need to download from Metalink? Any Name for it?
|
|
|
|
|
| Mohammed Taj |
| Posted: Apr 24, 2008 01:12:59 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
NO patchset.
you need to install oracle 10g software then you can upgrade your database
you have two choice 1. manually upgrade, 2. dbca or 3.export/import.
http://tahiti.oracle.com '''search word for "upgrade"'''
|
|
|
|
|
| Virusminus |
| Posted: Apr 24, 2008 09:04:11 AM | |
|
Total Post: 14
Joined: Jan, 2008
|
Thanks Taj, for the reply. This my first time doing an upgrade could you please tell me which is most preferable? Manual, DBCA or Export/Import??
|
|
|
|
|
| Mohammed Taj |
| Posted: Apr 24, 2008 10:00:45 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
If database size is small >=1gb or below then use EXPORT/IMPORT.
otherwise I personally refer MANUAL upgrade option becuase we have full control on upgrade process.
|
|
|
|
|
| Virusminus |
| Posted: Apr 24, 2008 11:35:09 AM | |
|
Total Post: 14
Joined: Jan, 2008
|
Thanks for the quick response Taj, well the database size is about 2.8GB so guess I do a manual upgrade, but I would consider taking a full export also before I do the upgrade. Thanks for the suggestion.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
