Hi James,
Somewhere on the net you will find Jared Still's SQL unloader utility
program.
Download a copy and you will then be able to generate the scripts you
need to
recreate your database under a different version of Oracle, the scripts you
need
to dump each of your tables to a flat ASCII file, and the SQL Loader control
files
you will need to load them in your new database.
I don't remember if Mr.. Still's utility package handles Stored
Procedures,
Grants, or Referential Integrity but you can pick those up using either
other
utility packages from the net or write your own.
regards
Jerry Gitomer
James wrote in message <01be8bda$baf06280$a446ea9e_at_P014299.logica.co.uk>...
>Hi All,
> I've run up against a rather awkward problem regarding the Oracle 8
>migration utility. Basically I've had to install Patch 80430 on top of our
>Oracle 804 installation, running on Solaris 2.6.
>
> This presents certain problems for the migration tool, in that we can no
>longer safely use it according to the patch installation notes. This is
>quite a problem as we need this patch immediately, but we also have an
>ongoing program of upgrading 7.x databases to 8.
>
> Oracle support say that there are no plans for a migration utility patch,
>and that the only work-around is to have two Oracle 8 installations: one
>with patch 80430, and one without. Accordingly, I'm going to have to move
>the current (patched)Oracle8 ORACLE_HOME to 8.0.4.3, and install a baseline
>Oracle 8.0.4 so that we can use the migration utility. Migrated databases
>will then have to be moved to the 8.0.4.3 installation!
>
>So my question is this: Is there an easier way of doing this, aside from
>exp/imp?
>
>Thanks in advance.
>James
Received on Wed Apr 21 1999 - 13:20:13 CDT
