Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 15660 invoked from network); 21 Dec 2007 05:39:02 -0600
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 21 Dec 2007 05:39:02 -0600
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6D7097DC84B;
 Fri, 21 Dec 2007 06:39:02 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 29898-04-3; Fri, 21 Dec 2007 06:39:02 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BB6067DD8B3;
 Fri, 21 Dec 2007 06:39:01 -0500 (EST)
Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 21 Dec 2007 05:51:35 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 553C97DCF9B
 for <oracle-l@freelists.org>; Fri, 21 Dec 2007 05:51:35 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 19589-06 for <oracle-l@freelists.org>;
 Fri, 21 Dec 2007 05:51:35 -0500 (EST)
Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 10D4F7DCF84
 for <oracle-l@freelists.org>; Fri, 21 Dec 2007 05:51:32 -0500 (EST)
Received: by wa-out-1112.google.com with SMTP id k22so457860waf.18
        for <oracle-l@freelists.org>; Fri, 21 Dec 2007 02:51:32 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
        bh=5YlZEF4gSL7INpPOPLne/3infVdtC7UJELHl6yLh02g=;
        b=gHPFuI3dnyJwW/1c/X9XrCDxx2w/1YyO0bstTk4YAkVnkyCYSonTcgqxT8LDql4rGvRS+MuyToaXeOoZx698cYWWsuBXEswQBY7ytpdYA1PQOJQ/qlbyW4gE7KtBOsLElaIehh2wVSNQypbEhodrekq19RDhtDuF279FLQRqlaA=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:mime-version:content-type;
        b=hEWy+9ZNWE5AromASV5K2aaFzRdZFz2dd+8aiv9tfXCc325N/E2gKt3tnlGnvu7L9+DaADrDVHKcqBMJfT1h4Vj2f8y5M8ueGKTKnXRGSXW8z22JqcRaFdumSfyfr7eli7EPrcmTF3gXTNDek+R2f3aufOUY/RdawqM/WydJjyo=
Received: by 10.114.176.1 with SMTP id y1mr1264645wae.86.1198234292452;
        Fri, 21 Dec 2007 02:51:32 -0800 (PST)
Received: by 10.114.77.17 with HTTP; Fri, 21 Dec 2007 02:51:32 -0800 (PST)
Message-ID: <887a5be30712210251i2edd4808j3d3298fb29d86af1@mail.gmail.com>
Date: Fri, 21 Dec 2007 16:21:32 +0530
From: "Anju Bala" <oraclebala@gmail.com>
To: oracle-l@freelists.org
Subject: export problem!!
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_31746_15747005.1198234292446"
X-archive-position: 4076
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: oraclebala@gmail.com
Precedence: normal
Reply-to: oraclebala@gmail.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain
------=_Part_31746_15747005.1198234292446
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_31746_15747005.1198234292446
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>hi list,</div>
<div>&nbsp;</div>
<div>I have one table with below structure:</div>
<div><font size="2">PPC_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER(15,5) </font></div>
<div><font size="2">LEADPOSTTIME&nbsp;&nbsp;&nbsp; DATE </font></div>
<div><font size="2">REFERRERURL&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(4000) </font></div>
<div><font size="2">REFERRERIP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(20) </font></div>
<div><font size="2">PPCNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VARCHAR2(40) </font></div>
<div><font size="2">PPCFORMNAME&nbsp;&nbsp;&nbsp; VARCHAR2(40) </font></div>
<div><font size="2">ROW_CREATE_DT&nbsp; DATE </font></div>
<div><font size="2"></font>&nbsp;</div>
<div><font size="2">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.</font></div>
<div><font size="2"></font>&nbsp;</div>
<div><font size="2">No DB level changes are done in past few months.</font></div>
<div><font size="2"></font>&nbsp;</div>
<div><font size="2">Any idea?</font></div>
<div><font size="2"></font>&nbsp;</div>
<div><font size="2">TIA,</font></div>
<div><font size="2">Bala</font></div>

------=_Part_31746_15747005.1198234292446--
--
http://www.freelists.org/webpage/oracle-l


