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

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.

.

Relevant Pages

  • Re: Whats the bcp (SQL Server) substitute in Oracle??
    ... secured UNIX server using the bcp utility of SQL Server. ... But now this database will be migrated to Oracle 10g. ... Flat File and Out File. ...
    (comp.databases.oracle.misc)
  • Re: Whats the bcp (SQL Server) substitute in Oracle??
    ... secured UNIX server using the bcp utility of SQL Server. ... But now this database will be migrated to Oracle 10g. ... Flat File and Out File. ...
    (comp.databases.oracle.misc)
  • Re: Messaging explained
    ... 'normally' means a single XML message, but not all of the time. ... variety of ways, to keep it simple, it drops a file off and BizTalk picks up ... the flat file parser converts it into an XML message and passes it ... flat file for importing into Server B. If Server B requires more information ...
    (microsoft.public.biztalk.general)
  • Re: BCP error 22001 - String data, right truncation
    ... application developers strip those types of garbage characters out before ... > Once I switched to native mode the problem went away. ... >> First be sure the table schema on the target server matches the one on ... >>>I am using bcp to copy a table from one sql server to another. ...
    (microsoft.public.sqlserver.tools)
  • RE: System.OutOfMemory Exception
    ... Consider creating a view in SQL Server that gets the data in the correct ... format and use a Process object to fire BCP to pull from this view. ... > to be "re-horizontalize" and served in a single flat file. ...
    (microsoft.public.dotnet.faqs)