Select * from table into outfile

[saw15]

I am trying to run the following from sqlplus:

SELECT * FROM myDatabase.claims_vw INTO OUTFILE 'c:\tmp\claims.txt' FIELDS TERMINATED BY '|';

But it is erroring out with: sql command not properly ended.

This is an 8i database.

Help is appreicated.

 

[venur]

Hi,

I think what you are trying above is MySQL statement to load data. In oracle if you need to exprot the Data into a flat file you need to do like one below.

spool outfile.txt
select * from myDatabase.claims_vw;
spool off


Cheers,
Venu

 

[sem]

The syntax is invalid. At least for Oracle.

Try something like

set colsep |
spool c:\tmp\claims.txt
SELECT * FROM myDatabase.claims_vw;
spool of

Regards, Dima

 

[saw15]

Thanks, that's what I thought.

Appreciate the quick response.