Re: import fails to import all rows.

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?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)