Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 15763 invoked from network); 21 Dec 2007 08:51:48 -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 08:51:46 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0ECEC7DCED1; Fri, 21 Dec 2007 09:51:46 -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 10985-09; Fri, 21 Dec 2007 09:51:45 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7924F7DC9C0; Fri, 21 Dec 2007 09:51:45 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 21 Dec 2007 09:04:19 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 771467DDAE3 for ; Fri, 21 Dec 2007 08:26:18 -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 22315-07 for ; Fri, 21 Dec 2007 08:26:18 -0500 (EST) Received: from outbound2-wa4-R.bigfish.com (outbound-wa4.frontbridge.com [216.32.181.16]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F021A7DCEE9 for ; Fri, 21 Dec 2007 08:26:17 -0500 (EST) Received: from outbound2-wa4.bigfish.com (localhost.localdomain [127.0.0.1]) by outbound2-wa4-R.bigfish.com (Postfix) with ESMTP id 61D4D472649; Fri, 21 Dec 2007 13:26:17 +0000 (UTC) Received: from mail82-wa4-R.bigfish.com (si1-wa4 [10.8.14.5]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by outbound2-wa4.bigfish.com (Postfix) with ESMTP id 60068AB005E; Fri, 21 Dec 2007 13:26:17 +0000 (UTC) Received: from mail82-wa4 (localhost.localdomain [127.0.0.1]) by mail82-wa4-R.bigfish.com (Postfix) with ESMTP id 31B9EC205A9; Fri, 21 Dec 2007 13:26:14 +0000 (UTC) X-BigFish: VP X-MS-Exchange-Organization-Antispam-Report: OrigIP: 12.23.250.36;Service: EHS Received: by mail82-wa4 (MessageSwitch) id 119824357489354_6074; Fri, 21 Dec 2007 13:26:14 +0000 (UCT) Received: from spobmexc02.adprod.directory (smtp.ingrambarge.com [12.23.250.36]) by mail82-wa4.bigfish.com (Postfix) with ESMTP id 4862B17A0098; Fri, 21 Dec 2007 13:25:58 +0000 (UTC) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C843D5.0420946F" Subject: RE: export problem!! Date: Fri, 21 Dec 2007 07:25:55 -0600 Message-ID: <17E4CDE8F84DC44A992E8C00767402E0860E08@spobmexc02.adprod.directory> In-Reply-To: <887a5be30712210251i2edd4808j3d3298fb29d86af1@mail.gmail.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: export problem!! References: <887a5be30712210251i2edd4808j3d3298fb29d86af1@mail.gmail.com> From: "Taylor, Chris David" To: , X-archive-position: 4082 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Chris.Taylor@ingrambarge.com Precedence: normal Reply-to: Chris.Taylor@ingrambarge.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------_=_NextPart_001_01C843D5.0420946F Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Need to provide more information. Database Version? Host Server? Host OS? Your export parameter file? =20 Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 Office: 615-517-3355 Cell: 615-354-4799 Email: chris.taylor@ingrambarge.com ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Anju Bala Sent: Friday, December 21, 2007 4:52 AM To: oracle-l@freelists.org Subject: export problem!! =20 hi list, =20 I have one table with below structure: PPC_ID NUMBER(15,5)=20 LEADPOSTTIME DATE=20 REFERRERURL VARCHAR2(4000)=20 REFERRERIP VARCHAR2(20)=20 PPCNAME VARCHAR2(40)=20 PPCFORMNAME VARCHAR2(40)=20 ROW_CREATE_DT DATE=20 =20 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. =20 No DB level changes are done in past few months. =20 Any idea? =20 TIA, Bala ------_=_NextPart_001_01C843D5.0420946F Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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@ingrambarge.com=

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Anju Bala
Sent: Friday, December = 21, 2007 4:52 AM
To: = oracle-l@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         &nbs= p;   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

------_=_NextPart_001_01C843D5.0420946F-- -- http://www.freelists.org/webpage/oracle-l