Re: export to ascii file

From: Pawe³ <pp_at_inwar.com.pl>
Date: 1997/04/02
Message-ID: <01bc3f3f$8beebde0$5d79b5c2@pp.system.inwar.com.pl>#1/1

Raul Sanchez <rsanchez_at_lingocd.com> napisa³(a) w artykule <333DC0E2.1FAB_at_lingocd.com>...
> Hi,
>
> I would like to know how or where I might find information on how
> to export a table to an ascii file in ORACLE (for example, in SYBASE
> I would use the following:
>
> bcp databaseName..tableName out dataFile -c .....
>
> In order words, what is the equivalent to this statement above
> in ORACLE. Thanx for you kind help in advance.
>
> --Raul
>

Try Command  

 Exp PARFILE=Parameters_File

%%
%% Parameters_File example
%%

USERID=user/password_at_connect_string
FILE=file_o_system
LOG=file_o_system
TABLES=(table_name,table_name,...)
%% End

Or in SQL*Plus

Spool file_o_system ;

select Field1,Field2,..... from Table ;
 or
select Func1(Field1),Func2(Field2),..... from Table ;

spool off ;

You must delete header.

Sory for my English.

Pawel Plichta
pp_at_inwar.com.pl Received on Wed Apr 02 1997 - 00:00:00 CST