sqlloader rows

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

sqlloader rows

Roshan
Oracle Database 12c
Red Hat Linux 6

Hi,

I am loading aroung 3.6 million rows in a table. After completion, the log says all rows successfully loaded.
But in the table only 3.3 million rows have been imported.
Please find attached.
sqlloader.rarsqlloader.png

Do you think I should provide less rows t export?


Regards,
Reply | Threaded
Open this post in threaded view
|

Re: sqlloader rows

Roshan

I have reviewed the sql

SQL> select count(*) from mobile_voice;

COUNT(*)
----------
3655699

I have removed the partition.
.The value now tallies with the number of rows exported.

Some rows have been inserted in last month's partition for table mobile_voice.

Thanks,
Roshan
Reply | Threaded
Open this post in threaded view
|

Re: sqlloader rows

ErmanArslansOracleBlog
Administrator
Good then..