Re: Whats the bcp (SQL Server) substitute in Oracle??
- From: Robert Klemme <shortcutter@xxxxxxxxxxxxxx>
- Date: Wed, 02 Aug 2006 12:54:38 +0200
riteshjain82@xxxxxxxxx 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
.
- Follow-Ups:
- Re: Whats the bcp (SQL Server) substitute in Oracle??
- From: riteshjain82
- Re: Whats the bcp (SQL Server) substitute in Oracle??
- References:
- Whats the bcp (SQL Server) substitute in Oracle??
- From: riteshjain82
- Whats the bcp (SQL Server) substitute in Oracle??
- Prev by Date: Re: "limit 10" vs "rownum <=10"
- Next by Date: newbie problem with analytic function
- Previous by thread: Whats the bcp (SQL Server) substitute in Oracle??
- Next by thread: Re: Whats the bcp (SQL Server) substitute in Oracle??
- Index(es):
Relevant Pages
|
