Re[2]: RE: RE: historical data

From: <dgoulet_at_vicr.com>
Date: Tue, 22 May 2001 18:25:21 -0700
Message-ID: <F001.0030B9EA.20010522181522@fatcity.com>

Well when you advertise that it can take 7 business days to restore the data fast is not a consideration.

Dick Goulet

---------------------- Reply Separator ----------------------

Author: Christopher Spence <cspence_at_FuelSpot.com> Date: 5/22/01 3:09 PM

Oh, yes agreed 110%.

But on another note, import/export is not fast. That is the only reason I
mention these other options.
But I agree 100%. The other difficulty is if you want to import that data
into a different format, exports do not help much as you have to import (Perhaps a big table) then convert it.

-----Original Message-----
Sent: Tuesday, May 22, 2001 2:59 PM
To: Christopher Spence; Multiple recipients of list ORACLE-L

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Christopher Spence
INET: cspence_at_FuelSpot.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------