Subject: | |
From: | |
Reply To: | Rudderow, Evan |
Date: | Thu, 26 Mar 1998 18:10:58 -0500 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
How about -
Get the Oracle Transparent Gateway for IMAGE/SQL, do "INSERT AS SELECTS"
to get the data into Oracle tables, then export the tables to flat files
- perhaps you can directly export from the IMAGE tables through the
Oracle gateway and so avoid the INSERT AS SELECT piece in the middle.
-- Evan
-----Original Message-----
From: Trudeau, James Lhrl [SMTP:[log in to unmask]]
Sent: Thursday, March 26, 1998 10:28 AM
To: [log in to unmask]
Subject: TurboImage to Oracle (Another one bites the
dust)
---------------------- Information from the mail header
-----------------------
Sender: HP-3000 Systems Discussion
<[log in to unmask]>
Poster: "Trudeau, James Lhrl"
<[log in to unmask]>
Subject: TurboImage to Oracle (Another one bites the dust)
------------------------------------------------------------------------
-------
Howdy,
So amongst all the other pains of transitioning from a 3000 to a
9000 :-(( I keep having cows about what to do with the 9 years
of offsite archive data we've got to deal with. It's all on
DDSII
tapes in MPE STORE format. It consists of TurboImage databases
COBOL source code and executables. Total of ummm 550-600GB.
If I can get it into some kind of reportable format on the 9000
I
can dispense with everything but the TurboImage data. Keeping
the 3000 after migration and loading up the tapes one at a time
and going through the same process we use for the current data
is not an option.
The stuff does not have to be online, it just needs to be more
or
less readily accessable. It's the freakin' auditors ya know.
All suggestions, excluding put it in the cow pasture, are
appreciated.
Jim (sleepless in Harlingen) Trudeau
|
|
|