RE: Can I DP Export to Excel
Date: Wed, 11 Feb 2009 06:51:58 -0600
If the table is fairly small, another option is to spool the content out to a file then import into excel.
From: oracle-l-bounce_at_freelists.org on behalf of Stefan Knecht Sent: Wed 2/11/2009 5:09 AM
Subject: Re: Can I DP Export to Excel
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:
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:
Stefan P Knecht
CEO & Founder
10046 Consulting GmbH
Cell +41 (0) 79 571 36 27
On Wed, Feb 11, 2009 at 1:22 AM, patrick obrien <po04541_at_yahoo.com> wrote:
> Hello Oracle Experts,
> In OEM, I can easily import a correctly configured flat file into a table
> using DP.
> can I export a table to a flat file using Data Pump's/Oracle 11g's standard
> Thank you,