Whats the bcp (SQL Server) substitute in Oracle??

From: <riteshjain82_at_gmail.com>
Date: 1 Aug 2006 22:57:08 -0700
Message-ID: <1154498228.267146.3480@s13g2000cwa.googlegroups.com>

Hi friends,

In my project right now we are creating flat files from tables on one secured UNIX server using the bcp utility of SQL Server.

But now this database will be migrated to Oracle 10g. Can i achieve the same functionality of bcp in Oracle?? I already have one procedure which can create one flat file on a fixed server location which will be specified in init.ora file.

But I want to create the three files that are created using the bcp i.e. Error File, Flat File and Out File. Also, I am not very clear about the difference between the Flat file and Out file generated by bcp. I also want to pass the secured server location as a parameter to this procedure.

Can anyone help me on this?? Please provide the code snippet as i am very new to Oracle.
This is really urgent friends, please help me. Received on Wed Aug 02 2006 - 00:57:08 CDT