Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tools for exporting data to flat file
Haven' found a specific tool - but I do get by fine with a seed job of pro-c ( or you could use oci) wrapped around a plsql block. The wrap around has one cursor - get the row seed. It then passes the distinct vars to the plsql block which retrieves all the named members of the table.
The end section of the pro-c takes the vars from the plsql block as bound variables and writes to file - retruning to the seed querry for execution until the fetch is exhausted.
I bind all the values into self-dimensioning arrays ( a little pro-c sub code) and it makes dealing with the specifics of column lenght less onerous - but a little tweaking isn't that bad.
I would like an automated tool as well - but have been too lazy to progress behind my little pro-c dump routine.
jds
Deborah Dawicki wrote:
> We are performing a database evaluation and it has been stated there is
> no other tools that will export to flat files except for spooling from
> SQL*Plus.. I mentioned import/export but those utilities don't export to
> a flat file.. Is there a tool or utility I'm missing that would export
> to flat file?
>
> Please reply to debor19071_at_aol.com
>
> Thanks alot.
Received on Thu Jun 21 2001 - 22:00:01 CDT