Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: upgrading to Oracle8 - couple of questions
Hi,
Export from Oracle7 and Import to Oracle8 works well, bue before to import
you have to strat script $ORACLE_HOME/rdbms/admin/catexp7.sql and set
REMOTE_LOGIN_PASWORDFILE=NONE.
That's the first method.
The second: you can use mig utility.
Regards
Krzysztof Cabaj
Oracle DBA
<farrellyr5408_at_my-deja.com> wrote in message
news:87pjrc$qic$1_at_nnrp1.deja.com...
> I am going to be upgrading our database to Oracle8 and I have a couple
> of questions on it. I will be doing it by Export/Import. Right now we
> have a test and production database, I will obviously do the test
> first. I will install the Oracle software in a new Oracle Home then I
> will create services then the database. Before I do the Import of the
> Oracle7 database, I have to create the datafiles/tablespaces, rollback
> segments etc., does the path name for these files matter? I'm just a
> little unsure how the import works and how all these files will be
> imported into the correct file. I'm also a little unsure of what has
> to be in the create database script.
>
> Thank you for your help.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Feb 10 2000 - 08:31:13 CST