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

riteshjain82_at_gmail.com wrote:
> 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.

There are several tools, the most similar probably being SQL*Loader. You can find it in the "Utilities" book. It's unlikely though that you'll achieve the exact same functionality you have with bcp.

Then there's exp and imp and Oracle Data Pump for moving of data.

Kind regards

        robert Received on Wed Aug 02 2006 - 05:54:38 CDT