Re: import fails to import all rows.

From: Cookie Monster <cookie.monster_at_somewhere.com>
Date: Wed, 17 Dec 2003 17:30:55 +0100
Message-ID: <brq0av$66g1m$1@ID-82797.news.uni-berlin.de>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1071675382.82384_at_yasure...
> Cookie Monster wrote:
>
> > Hi,
> >
> > I have an export from oracle 8.1.7 and attempting to import a table into
> > oracle 9.2.0.4. My table has 100,000 rows but only 30,000 rows are
imported.
> > No errors are given. The table does have one clob column.
> >
> > I'm using standard export (not direct).
> >
> > Does anyone have any hints on how I can resolved this problem.
> >
> > Thanks.
>
> Are you importing into an existing table that already has constraints
> and/or triggers or is the import creating a new table?

No, I am importing into a completely new database. It's clean, nothing in there.

Steve. Received on Wed Dec 17 2003 - 10:30:55 CST