Re: The Transition from Oracle 6 to 7 - any problems?

Paultje Bakker (bakker_at_cs.uq.oz.au) wrote:
: A message from my brother, who a few months ago posted some very popular
: scripts here.
 

: ----------------
: Greetings, DBAs of the World,
 

: Could some kind soul please send me a true-life experience of the migration
: from Oracle 6 to 7, as seen from a DBA's point of view? I can easily
: get the official line, but I'm more interested in the pitfalls, and a
: general indication of how easy/hard it is. Handy scripts would be very
: much appreciated.
 

: merci bien,
: Rick Bakker, Deepest Darkest Africa

Hi there !
I'm just in the process of migrating about 15 running versions of our nation-wide journaling systems, which currently run under ORACLE 6.0.36.1.1 to ORACLE 7.0.15.6.0.
I'm looking forward !"#Ï to this task, and the way I'm going to do it is this :
I'll export my old tables, create new ORACLE7 databases and tables, and then I'll import the table data. This reason for this is, that I'm not confident in ORACLE's migration tool (neither are ORACLE !), and I want to add constraints and things to my new tables.

If you would like to know more about the progres of this venture, please email me and I'll try to keep you up to date.

 --

- Tom Kruhlmann                      - Tel +45 42890501, 2327            -
- LODA/KON3 Forsvarets Datatjeneste  - Fax +45 45660571                  -
- Danish Defence Dataservice         - Email tok_at_login.dknet.dk          -
         The facts, although interesting, are irrelevant