exporting an oracle db table to a flat file

[camja]

Hi, I want to export an oracle database table to a flat file - can anyone tell me how to do this ?

[debasisdas]

Hi camji

Welcome to TSDN.

Try to use SPOOL command from SQL*PLUS.

ex
======
spool 'd:\data.txt'

select * from inventory;

spool off

next check for the file. if the file does not exist that will be created.

[amitpatel66]

Use IMPORT command in case if you want to import from one database and export it to another database

imp scott/tiger file=emp.dmp full=yes
imp scott/tiger file=emp.dmp fromuser=scott touser=scott tables=dept

[camja]

Hi camji

Welcome to TSDN.

Try to use SPOOL command from SQL*PLUS.

ex
======
spool 'd:\data.txt'

select * from inventory;

spool off

next check for the file. if the file does not exist that will be created.

Thankyou ! so simple and obvious really - great.