topic Do I need to upgrade database objects ? in Operating System - HP-UX

Do I need to upgrade database objects ?

Massimo_37 — Fri, 11 Jun 2004 04:07:58 GMT

If I am doing the following steps in order:
1)Install Oracle 7.2.3 software on a new server(no database created)
2) upgrade to 7.3.4
3) Create a database
4)Import from a full back of a database on 7.3.4
My question is, in the above scenario,
do I have to perform the task named "Upgrade databse Objects"(for each SID)- as mentioned on the upgrade manual ? (As there won' be any database at the time of upgrade)
Or is "Upgrade Database Objects" step required to upgrade any internal structures in Oracle
Many Thanks

Re: Do I need to upgrade database objects ?

Victor Fridyev — Fri, 11 Jun 2004 04:16:42 GMT

Hi,

As far as I know, a db restore via export/import doesn't require any DB upgrade.
BTW, don't you want instead 7.3.4 to use 7.3.4.4? 7.3.4 has much more bugs than 7.3.4.4

HTH

Re: Do I need to upgrade database objects ?

malay boy — Fri, 11 Jun 2004 04:20:25 GMT

wow!! 7.3.4 .I saw this beast last 6 years ago while working with Motorola.Basically export/import no need to upgrade database objects.

regards
mB

Re: Do I need to upgrade database objects ?

Fred Ruffet — Fri, 11 Jun 2004 04:35:10 GMT

No you don't. You would have done wether your DB had been created betwwen step 1 and 2. As long as this is not the case, you don't have to refer to "Upgrade database objects".

Regards,

Fred