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

Home -> Community -> Usenet -> c.d.o.server -> Re: exporting ASCII file from Oracle8

Re: exporting ASCII file from Oracle8

From: <ashesh48_at_my-dejanews.com>
Date: 1998/05/28
Message-ID: <6kjp06$12k$1@nnrp1.dejanews.com>#1/1

May be u can try this one for exporing the columns... EXP uid/pssword_at_netstring grants=N indexes=N rows=N constrintns=N file = abc.dmp Hope this should work. AShesh.

In article <356C6248.1B5FC515_at_email.mot.com>,   Henry Fu <hfu01_at_email.mot.com> wrote:
>
> As far as I know, you cannot export columns from a table using Oracle's
> exp/imp utilities. You can do this in two ways:
>
> 1. Write a SQL script and save the result into a file. Append the output
> data file to the existing ASCII file.
> 2. Attach the table into a MS Access database. Create a query to select
> the columns. Import the ASCII file into the Access database. Then join
> the two together.
>
> Hope this will helpful.
>
> mustafah_at_criticalsys.com wrote:
> >
> > I am trying to export specific columns from an Oracle8 table into an ASCII
> > tab delimited file, I can't seem to find the utility that will perform this
> > functionality. The utility has to be compatible with Oracle7.3 also.
> >
> > Another related question is: can I append the exported data to any existing
> > ASCII file.
> >
> > Any suggestions are greatly appreciated.
> >
> > Thanks
> > Mustafa
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
> --
> Henry Fu
> Senior SAP Oracle DBA
> Motorola Inc.
> Cellular Infrastructure Group
> Tower 1, Floor 7
> Rolling Meadows, IL 60008
> 847-435-7144 (Office Phone)
> 847-435-7577 (Fax)
> hfu01_at_email.mot.com
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 28 1998 - 00:00:00 CDT

Original text of this message

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