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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx > ------------------------------ > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Anju Bala > *Sent:* Friday, December 21, 2007 4:52 AM > *To:* oracle-l@xxxxxxxxxxxxx > *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 >