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 <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
