| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: RE: historical data
Chris,
Humm, did not think that was clear, but!! We started using export to extract data from our operational data store back in 92 with Oracle Version 5 to tape. These files, copied now to CD's are still usable with Oracle 8i. That's 10 years and no problems. If I can depend on something with Oracle, they maintain a backwards compatibility with the import tool that I haven't found the end of yet.
Dick Goulet
____________________Reply Separator____________________ Author: Christopher Spence <cspence_at_FuelSpot.com> Date: 5/22/2001 2:20 PM
I am not sure what you are saying here, but ok sure.
-----Original Message-----
Sent: Tuesday, May 22, 2001 1:31 PM
To: Christopher Spence; Multiple recipients of list ORACLE-L
Chris,
I've been exporting data in a similar way as you since V5. The 8i
version
of import still reads them without trouble.
Dick Goulet
____________________Reply Separator____________________ Author: Christopher Spence <cspence_at_FuelSpot.com> Date: 5/22/2001 7:13 AM
Take a look at Thomas's Kytes utility "Data Unloadder" on his website.
Also look at Oriole's PDQ OUT. Both products will avoid the need to
recreate the wheel.
Also, toad can do this.
-----Original Message-----
Sent: Monday, May 21, 2001 6:17 PM
To: Multiple recipients of list ORACLE-L
We have to role off partitions of data every week and I am writing a script
to
write the data to comma separated files using utl_file. What I was wondering
is
does anyone have an alternative that is better? I thought about using export
but
thought it wouldn't be fun trying to import an export file into the latest
version
of Oracle 10 years down the road.
Thanks, Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David Turner
INET: turner_at_tellme.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue May 22 2001 - 14:02:45 CDT
 |
 |