Re: Oracle Newbie Question

From: <kal121_at_yahoo.com>
Date: Wed, 09 Dec 1998 14:43:51 GMT
Message-ID: <74m2b7$4a5$1@nnrp1.dejanews.com>

So far I have not found a way. What I do is create an ODBC connection to my Oracle tables in Access - Access will allow you to create comma, tab, or anything you want, delimited flat files. However, it always appends the time to dates (SQLServer format) - so you'll have to clean this up afterwards with a search and replace.

In article <kwbb2.2207$45.3271699_at_WReNphoon1>, MarxR_at_claruscorp.com ("Marx, Robert") wrote:
> Is there any way to dump a table in Oracle 7.3 to a
> flat file...in much the same way that the bcp utility
> can be used in Sybase and SQL Server.
>
> I would have thought that SQL Loader would allow
> something like this.
>
> Any help in greatly appreciate.
>
> Thank you,
>
> -**** Posted from remarQ, Discussions Start Here(tm) ****-
> http://www.remarq.com/ - Host to the the World's Discussions & Usenet
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 09 1998 - 08:43:51 CST