Re: backup

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
rsnowden_at_NOTus.oracle.com <-- to reply, remove the obvious.

Andreas Doerler wrote:
>
> 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>
Received on Sat Dec 19 1998 - 12:18:59 CST