Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: RE: RE: historical data

RE: Re[2]: RE: RE: historical data

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Tue, 22 May 2001 21:07:19 -0700
Message-ID: <F001.0030BA4D.20010522205525@fatcity.com>

 I would hate to have to say it would take 7 days to do a restore.

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 5/22/01 10:15 PM

 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
--------------------------------------------------------------------
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:
  INET: dgoulet_at_vicr.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
--------------------------------------------------------------------
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 - 23:07:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US