RE: Can I DP Export to Excel

From: Newman, Christopher <>
Date: Wed, 11 Feb 2009 06:51:58 -0600
Message-ID: <>

If the table is fairly small, another option is to spool the content out to a file then import into excel.
  • Chris

-----Original Message-----
From: on behalf of Stefan Knecht Sent: Wed 2/11/2009 5:09 AM
Cc: oracle-l
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
Schwarzackerstrasse 29
CH-8304 Wallisellen

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27

On Wed, Feb 11, 2009 at 1:22 AM, patrick obrien <> 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

Received on Wed Feb 11 2009 - 06:51:58 CST

Original text of this message