Re: 7.0.15 upgrade to 7.3 on Netware 3.12

On Tue, 09 Jun 1998 22:00:02 GMT, ekyu_at_asgnet.psc.sc.edu <ekyu_at_asgnet.psc.sc.edu> wrote:
>Dear Oracle Admins:
>
>A client of ours is running Netware 3.12 and Oracle 7.0.15. We have to
>upgrade them to Oracle 7.3. Assumes that I've got good backups and stuff, my
>approach is either going to be
>
>1) upgrade from 7.0.15 to 7.3
>
>or
>
>2) export the database and re-install a brand new 7.3 instance and re-import
>the entire export (from 7.0.15)
>
>Which one is a better choice?

You can use either one, the export/import allows you to change the blocksize if you want, and has the side-effect of defragmenting the db. As long as you are doing something this major, it doesn't hurt much to check that the database sizing and such haven't changed since the db was originally created.

>
>If I'm using method 1. Do I have to upgrade multiple times from 7.0 -> 7.1 and
>from 7.1 -> 7.2 then eventually 7.3?

You should be able to go direct. Check your install guide.

>
>If I'm using method 2. Will the export (.dmp) dump file generated by 7.0.15
>database be able to import back to a 7.3 database?

I think so, provided you haven't added anything dependent on post-7.0 features. Never tried it, personally. I seemed to have a lot of problems with exp in early 7, so I developed the habit of keeping tables in ASCII.

>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.