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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Export/Import

Re: Export/Import

From: Michael Daskaloff <mdaskalo_at_tlogica.com>
Date: Fri, 10 Dec 1999 13:39:26 +0200
Message-ID: <3850E66E.18B6EFD0@tlogica.com>


Hi Bojan,
you can see the Oracle Tools section in the Homepage of Erwin Dondorp at http://home.wxs.nl/~erwindon/

You can also use on Windows Golden Tools (not freeware) - see http://www.benthicsoftware.com/

There are many others.

I myself would use SQL*Plus because it's absolutely platform indepenent.

Regards,
Misho

Bojan wrote:

> I want to export data from Oracle to a text file. Since Oracle doesn't have
> export/import utility, which is sad (it has, but only from/to Oracle - dump
> files), I am using SQLPlus to spool query output to a file.
> Is there a way to exclude query text at the begining and prompt at the end
> of the output file? I just want the data, no headers etc.
> I set all parameters to OFF, but it didn't help.
> Also, what 3rd party software would you recommend for export/import,
> something similar to SQL Server's DTS, with all formats (text, dBASE,
> Access, etc etc)?
>
> Best regards.
Received on Fri Dec 10 1999 - 05:39:26 CST

Original text of this message

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