Re: Migration to 8.05

a full export and import should work perfectly.

if you take a full export, you need not create any tablespaces or users..... the import does that.
however, you might like this opportunity to resize your tablespaces. so you might like to create the tablespaces correctly (with the same names as before) on the new database and then do the import. (the tablespace creation during the import will fail but that is no problem.)

you can do it on the same machine also, but i would like to think that if you have a spare machine, that might be best as you can then install the OS and the database again.

regards,
nitin.

sjl <sorry_at_noemail.com> wrote in message news:7n53ma$6bm1_at_iac7.navix.net...
> We've got a relatively small Oracle 7.3.3 database (approx. 2GB) that we
> need to get migrated to version 8.05. I've tried to read and understand
> Oracle's docs on the Migration Utility and Migration Assistant - I've even
> gone so far as to actually try and use these "tools". However, I get
> nowhere fast. Oracle's own docs don't follow along with what I'm actually
> seeing on the screen and I'm left hanging with no migration.
>
> My question: is the export/import option a good idea? My thinking is
that
> I could just do a full export from the 7.3.3 db and then turn around and
do
> a full import into a fresh 8.0.5 environment. Can I do all of this on one
> machine (without too much hassle)? Or do I realistically have to have
> another box to install the new 8.0.5 onto? In order to import the .dmp
> file, do I just need to re-create my tablespaces and that's it prior to
> importing?
>
> Anybody had any experience with this that could offer any assistance?
> Thanks in advance.
> sjl
>
>
Received on Fri Jul 23 1999 - 13:44:09 CDT