Moving a database and upgrading.

[marknel]

I've been tasked (with no practical knowledge by the way) to take an Oracle 8.0.5 database running on an NT4 box and move it to a brand new Win2k box running 8.1.7. It has to be 8.1.7 due to the age of the application and even then, technically the app is only supposed to work on 8.0.5.

So I learned about import/export. Being that this is a physical server move and nobody had any idea where the 8.0.5 oracle cd's were, import/export seemed to be the way to go.

I have been able to export the tablespace needed, and imported it into 8.1.7.

I've written the scripts to recreate the users and grants.

I've duplicated the necessary dblinks (did this yesterday).

For someone that only has a passing knowledge of oracle, this was a journey.

Now someone has found the 8.0.5 CD.

My questions are these:

1. Should I scrape all the work I've put into this to this point, remove 8.1.7 from the 2k box, install the 8.0.5 and do a full export/import into the new 8.0.5 and then do a 8.1.7 upgrade?

1.1 Is it relatively easy to remove 8.1.7?

2. The steps to recreate the database on the 8.1.7 using the import/export method to the new server seem simplistic when I list them:

a. Export the tablespace from the production 8.0.5 (off hours ofcourse)
b. run my create script for the tablespace in the 8.1.7 database
c. run the create user scripts on the new database.
d. import the exptblspace.dmp file
e. run the grants.sql to apply the grants to the various users.
f. recreate the necessary database links to remote databases.


What am I missing?


Thank you all in advance.

Mark Nelson
-Dogpaddling in the sea of the unknown

[robertbalmer]

I WOULD

1.CREATE NEW DATABASE ON 8.7
2.RUN YOUR CREATE SCRIPTS for tbspaces,user,grants
3. IMPORT THE EXP.DMP FROM 8.5 ON 8.7
(4. USE PARAMETER "OWNER=(..,...)) NOT FULL=Y

Shouldn't experience any problems

[davey23uk]

one thing though, 8.0.5 is old and unsupported on Win2k - you might encounter problems.

But export / import is probably the way to go here

[marknel]

Thank you for the replies. I'm moving down the export/import path and have tested the create_tblspces script, the cr8_users, imported the data, ran the cr8_grants (found I forgot a user in the cr8_users).

Got the database links created.
**NOTE Search is a wonderful thing. After searching an error I was getting, I did a search here and found that setting global=false solved my problem**

Now the plan is to comeing on Saturday and run another export of the user tablespace and run the full (and hopefully final) test import on Sunday.

Thanks again for the input!

Mark