Re: Can I DP Export to Excel
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: po04541@xxxxxxxxx
- Date: Wed, 11 Feb 2009 12:09:45 +0100
With data pump you can't do flat files. Data pump can only use an
oracle-specific binary format.
What you want to be looking at is sql*loader:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/ldr_concepts.htm#i1005437
To unload a table to a flat file, there is no "real" method provided by
oracle. Several alternatives of doing it can be found here:
http://asktom.oracle.com/tkyte/flat/index.html
Cheers
Stefan
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Wed, Feb 11, 2009 at 1:22 AM, patrick obrien <po04541@xxxxxxxxx> wrote:
> Hello Oracle Experts,
>
> In OEM, I can easily import a correctly configured flat file into a table
> using DP.
>
> But,
>
> can I export a table to a flat file using Data Pump's/Oracle 11g's standard
> features?
>
> Thank you,
> Patrick
>
>
Other related posts:
