Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: export problem!!
Database version: Oracle 9i R2 ( 9.2.0.4.0)
Host OS : Linux plain.rackshack.net 2.4.21-15.ELsmp #1 SMP Thu Apr 22
00:18:24 EDT 2004 i686 i686 i386 GNU/Linux
Export Parameter: DIRECT=y COMPRESS=y tables=(ppcreferrer)
even spool also seemed to hang. My requirement is to provide all data from
this table to the manager in excel format for which i tried some tools like
TOAD,AQUA etc and then tried spooling the output directly to excel using
SET MARKUP HTML ON
SPOOL DATA.XLS
SELECT * FROM PPCREFERRER;
But this also hangs without any further details. Please provide me some
inputs on this..
TIA Bala
On 12/21/07, Taylor, Chris David <Chris.Taylor_at_ingrambarge.com> wrote:
>
> Need to provide more information. Database Version? Host Server? Host
> OS? Your export parameter file?
>
>
>
> *Chris Taylor*
>
> *Sr. Oracle DBA*
>
> Ingram Barge Company
>
> Nashville, TN 37205
>
> Office: 615-517-3355
>
> Cell: 615-354-4799
>
> Email: chris.taylor_at_ingrambarge.com
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Anju Bala
> *Sent:* Friday, December 21, 2007 4:52 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* export problem!!
>
>
>
> hi list,
>
>
>
> I have one table with below structure:
>
> PPC_ID NUMBER(15,5)
>
> LEADPOSTTIME DATE
>
> REFERRERURL VARCHAR2(4000)
>
> REFERRERIP VARCHAR2(20)
>
> PPCNAME VARCHAR2(40)
>
> PPCFORMNAME VARCHAR2(40)
>
> ROW_CREATE_DT DATE
>
>
>
> with just 47k records, problem here is when i am exporting the data using
> EXP/TOAD to DMP file/excel, it exports first 90 rows and then nothing
> happens.
>
>
>
> No DB level changes are done in past few months.
>
>
>
> Any idea?
>
>
>
> TIA,
>
> Bala
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 27 2007 - 00:09:27 CST