Re: Copy Oracle database to DB2/400

["Paul Raulerson" <praulerson@xxxxxxxxxx>]

Snort - if it is in Oracle, tell them to do a dump of the database schema.
For 6000 tables,
it should take perhaps, 10 minutes or so of their time. What it will
generate is the SQL that
will tell you exactly how the tables are related to each other, and in fact,
enable you to recreate
the database if you need to.

This is *not* something unusual for Oracle DBA's - in fact it is so common I
would say they are
feeding you a line of B.S. Push them a little bit, tell them you understand
thier time is valuable,
so just give you a dump of the database schema *along* with the data and you
will be on your
way...

Then complain like the devil to their managment once you get what you need.
:)

-Paul

----- Original Message -----
From: <David.X.Kahn@gsk.com>
To: <midrange-l@midrange.com>
Sent: Thursday, November 01, 2001 5:44 AM
Subject: Re: Copy Oracle database to DB2/400


> Unfortunately it's not going to happen. The group who look after the
legacy
> package have simply and categorically refused us access to the database.
> Instead they will provide flat file extracts of the data as and when we
> specify. The Oracle database apparently contains > 6,000 tables, and our
> demands on their time explaining how all these tables fitted together
would
> be excessive. Oh well, I suppose I can live with that although we cannot
be
> sure the extracts are full and correct until we reconcile the eventual JDE
> outputs back to those of the legacy system.
>
> Dave...
>
> "Achilles only had an Achilles' heel; I have a whole Achilles' body." -
> Woody Allen
>
> =======================================================
> The opinions expressed in this communication are my own and do not
> necessarily reflect those of my employer.
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>