Re: Export data from Oracle to another SQL server ???

That won't really solve my problem. I need to dump out large tables and then process the ASCII data. It is not feasible to put a few million rows in my clipboard & then paste it into Excel, save as a .csv file,etc. What I'm really looking for is some command line utility that would dump to delimited or fixed width (like BCP in SQLServer). I was hoping for something like EXP with some special arguments that I can't find.

linker_at_ilovechocolate.com wrote:

> Hi Peder,
>
> I have developed a small but powerful utility with which you can solve
> your problem. It allows you to query Oracle and paste the values into an
> excel spreadsheet. In Excel you can save that data into a comma delimited
> file.
>
> My tool is called Oraxcel and is very user friendly. When installed or
> just opened it appears as a new menu item called Oracle. Simply logon to
> your Oracle DB and put the query in and there you go....
>
> Please have a look at he Oraxcel homepage at:
> http://members.aol.com/gjlinker/projects/oraxcel
>
> There are screenprints available on that page.
>
> Kind regards, Gerrit-Jan Linker
>
> In article ,
> Brian Hall wrote:
> >
> > On a related subject:
> > I am trying to export data from an Oracle DB for other reasons, and all I need
> > is ASCII fixed or delimited. It seems that the EXP & SQLLoader products do
> > Oracle specific formatting which I don't want. Is there a better way to do
> > this without having to get a 3rd party product. I'd rather do this without
> > having to spool SELECT statements or buying more software.
> >
> > Thanks in advance,
> > Brian Hall
> >
> > Peder Holst wrote:
> >
> > > Sergei,
> > > For the migration or replication of data between the two - check and
> > > download
> > > SQLMover from http://www.sqlmover.com. It handles Oracle LONG, SQL Server
> > > Text, Image and Binary datatypes. Use the Intersolv ODBC driver for Oracle
> > > and the full evaluation key 1KKJBFJYF for SQLMover.
> > > Peder Holst
> > > pederh_at_elektrosoft.se
> > >
> > > Sergei Didur wrote in article
> > > ...
> > > > Hi everybody !
> > > >
> > > > I'd like to unload data from Oracle DB and then load it to Sybase.
> > > > I'm looking for something like Sybase BCP utility for Oracle.
> > > >
> > > > Thanks in advance,
> > > > Sergei Didur
> > > >
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Mon Dec 08 1997 - 00:00:00 CST