Re: Export table into flat text files

From: <gmei_at_my-deja.com>
Date: Mon, 21 Feb 2000 15:39:23 GMT
Message-ID: <88rm7a$76v$1@nnrp1.deja.com>

In article <38B0DFCF.8ADFC8B_at_junpg.net>, Jun Garcia <jgarcia_at_junpg.net> wrote:
> Hello. We're kind of knew to Oracle and we need to export all the
tables
> in our database into flat text files. Can anyone please guide us on
how
> to do this? Thanks.
>
>

Depending upon how large and complicated your database is. One simple way is to write a sql script to export table data. For example, script a script file called "export_my_dayabasename.sql" (on unix):

this will export all data in table1, table2,...
into file /user/local/my_database_name/export

spool /user/local/my_database_name/export/export_data.table1; /
select * from table1;
/
spool off;
/
exit;

end of sql script

Then you do similar stuff foe other tables as well. You will run these scripts in sqlplus to do the export.

Hope this helps

Guang

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 21 2000 - 09:39:23 CST