| |
 |
|
Donald K. Burleson
Oracle Tips |
Test the Oracle Migration
Process
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
mentioned here.
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.
|
