Re: looking for upgrade time estimate

Hi!

Only your data dictionary and SYSTEM tablespace will grow (because 2 dictionaries have to be stored meantime). Your datafiles will remain exactly the same (except the header block).

The migration with mig utility can be done within few hours. If you want to migrate using export/import, you might want to search for "import performance" in metalink (note: 93763.1 for example). There are other good documents around as well, though all of them lack some good advices such as single task linking or performing export/import in several steps (e.g. full import with rows=n indexes=n at first to get the pl/sql and structures in place, then importing only rows (or DLI over dblink)) to reduce the downtime even more.

Tanel.

"Vince Laurent" <eAddict_at_yahoo.com> wrote in message news:p5oc6vs42hu7l6584skvgt8696109jkgcl_at_4ax.com...
> I guess to be clearer, we will be taking an exisiting 8.1.7.3 server
> and upgrading it in place to 9i (whatever flavor is the latest for
> HPUX when I get around to doing it). Since the disk requirements for
> 9i are MUCH larger than they were for 8i, I am guessing the migration
> will take a bit of time.
>
> Thanks for the response.
>
> On Thu, 06 Mar 2003 06:42:09 +1100, "Howard J. Rogers"
> <howardjr2000_at_yahoo.com.au> wrote:
>
> >On Wed, 05 Mar 2003 13:22:52 +0000, Vince Laurent wrote:
> >
> >> Anyone have a time estimate for upgrading from 8.1.7.4 to 9i? I have a
> >> 100G databse I need to upgrade.
> >>
> >> Thanks!
> >> p.s. OS version HP-UX 11.0
> >
> >Depends how you propose to upgrade (technically, migrate). The Migration
> >Assistant, or the command line equivalent, aren't actually
size-sensitive.
> >Most of what they do is poke around inside the data dictionary, so 100GB
> >or 1GB, it makes no significant difference.
> >
> >Do the migration with export/import however, and the length of time it
> >takes will indeed vary with the amount of data.
>
Received on Wed Mar 05 2003 - 16:29:13 CST