hi

i just have taken over the dba role and have to
migrate a 7.3.2 dbs to oracle 8. its running
on digital unix and contains quite a lot of
schemas with complex interactions, so i have to
migrate it "as a whole" to the new system.

how can i create an empty o8 database (currently
i just have installed the software) and then
put the contents of the old one (i have a
export all file) properly into this system?

which scripts/programs are used for this task?
i just found vague information in the docs,
maybe i'm searching on the wrong place

thanks in advance!

  <ad>

Well, the migration utility or a full import/export are the routes to
go. Choose one of. Read up in the docs.

But first: get some training. These are very basic questions to be
asking for someone who has to migrate, build and maintain a production
system. It's very easy to make one mistake and{*filter*}things up
completely.

Just my take.

MotoX.

Andreas-

Migration to O8 is actually pretty straightforward. Basically, you
import the thing as-is and bring up the instance. But... bear in mind
that going back to O7 is a hassle. You can export the O8 db in O7 form,
but that requires the O7 export binaries and the associated message file
and you have to run a script on the O8 server to make the export work.
Plus, any new O8-specific stuff like CLOBs cannot be exported back.

So, you might get ready for a one-way trip. You also need to test the
software pretty carefully before you go live, especially if you are
using stored procedures and triggers.

Roger

Roger Snowden
Sr. Systems Engineering Specialist
Oracle Corporation