Donald K. Burleson
Test the Oracle Migration
Oracle offers a plethora of new
features, including automated rollback (now called undo) segment
administration, multiple block sizes in the SGA, and tablespaces,
and the ability to change SGA parameters on the fly. You may be
shifting to the new release to overcome bugs that were present in
the previous release, or only for specific new features that arenít
I want to make a statement here that Iím sure will have some folks
shuddering: If you are completely happy with your application, donít
force fit it into these new features. Change for the sake of change
is foolish. If there is a good, viable reason to implement these new
features, by all means do so, but donít be a lemming and just follow
the herd over the cliff. Oracle will function very well with an
Oracle8i application resting inside of it. Donít feel that you must
convert your applications immediately to the new features. Take some
time and get familiar with the ride of the new database, and watch
for its quirks before you start pell-mell into conversion.
Oracle MIG utility
No, this isnít a new Russian fighter plane. MIG is the migration
utility that Oracle has provided to get your Oracle7 database into
an Oracle database. Essentially, there are two main paths and a
rocky third to migrate from Oracle7 to Oracle. These are:
This is an
excerpt by Mike Aultís book ďOracle
Administration & ManagementĒ. If you want more current Oracle tips
by Mike Ault, check out his new book ďMike
Aultís Oracle Internals Monitoring & Tuning ScriptsĒ or
Aultís Oracle Scripts Download.
Copyright © 1996 - 2014 by
Burleson. All rights reserved.
Oracleģ is the registered trademark
of Oracle Corporation.