Oracle-L: RE: Oracle From a Sybase DBA perspective| What is a Database to S

From: Toepke, Kevin M <ktoepke_at_trilegiant.com>
Date: Mon, 01 Apr 2002 08:03:37 -0800
Message-ID: <F001.00437D42.20020401080337@fatcity.com>

There is code for a basic "SQL Unloader" tool available at asktom.oracle.com. Completely dynamic. Limited support for LONGs and no support for LOBs or objects, but generally pretty good. Does bulk fetches.

http://osi.oracle.com/~tkyte/flat/index.html

-----Original Message-----
Sent: Monday, April 01, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L S

bcp out - It's time Oracle came up with some utility to extract the data in ascii format other than recommending "sqlplus and spool"

What about utl_file functions?

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.

--

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

Author: Freeman, Robert
INET: Robert_Freeman_at_csx.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: Toepke, Kevin M
INET: ktoepke_at_trilegiant.com

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