RE: Can I DP Export to Excel
Date: Wed, 11 Feb 2009 06:51:58 -0600
Message-ID: <565F609E6D736D439837F1A1A797F34101E10A88_at_ADMINMAIL1.ui.uillinois.edu>
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: oracle-l-bounce_at_freelists.org on behalf of Stefan Knecht
Sent: Wed 2/11/2009 5:09 AM
To: po04541_at_yahoo.com
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:
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_at_10046.ch
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch
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.
>
> But,
>
> can I export a table to a flat file using Data Pump's/Oracle 11g's standard
> features?
>
> Thank you,
> Patrick
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 11 2009 - 06:51:58 CST