Re: Export problem

From: Allan Plesniarski <aplesnia_at_my-deja.com>
Date: 2000/05/15
Message-ID: <8fpp0f$444$1@nnrp1.deja.com>#1/1

We have a 200+ column table on AIX and HP with no similar problems. Are you using consistent=y?

The only case where I have seen exp take longer to do the same job is that a user export of stored procedures takes longer than a full database export including the same procedures.

In article <392037CA.A1BC17AD_at_euclidsys.com>, Randy DeWoolfson <randy_at_euclidsys.com> wrote:
> imagine the overhead in general of a table with so many columns...
>
> try making about 20 tables that are logicaly linked with primary keys
> out of this mess and see what happens...
>
> bet it gets better.
>
> randy
>
> Richard Dengler wrote:
>
> > We use NT4.0 and Oracle 8.0.4.
> > A data export with exp80 takes 2 minutes, even if the source
> > table is empty. During the export NT apparently nearly
> > completely stops responding to any user input.
> > The problem seems to be related with the number of columns in
> > the table (the table contains about 230 columns).
> > What can be done?
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon May 15 2000 - 00:00:00 CDT