Re: import fails to import all rows.

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 17 Dec 2003 15:02:18 -0800
Message-ID: <1071702043.832809@yasure>

Billy Verreynne wrote:

> "Cookie Monster" <cookie.monster_at_somewhere.com> wrote
>

>>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.

>
>
> To add to Daniel's reply..
>
> How sure are you that 100,000 rows were indeed exported? Maybe the
> 30,000 rows mean that just 30,000 rows exist in the export dump file?
>
> What are the export and import parameters?
>
>
> --
> Billy

Good point. Cookie ... perform your export and import using the LOG parameter and read the created log to verify that what you think is happening is, in fact, happening.

-- 
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)

Received on Wed Dec 17 2003 - 17:02:18 CST