SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Import data via TOAD is successful, but the rows are not inserted

ProkopisApr 15 2019 — edited Apr 15 2019

Hi all,

I have construct a table and I am trying to import data using

TOAD version 10.1.1.8

Oracle DB 11g

The problem I have is that whereas my file contains 700.000+ rows, after import only some of them are imported (~450000).

The import process finishes with successful message (without failed records).

Moreover, I have observed that the loading bar during import process is not inline with the data.

Is this memory issue ?

Any ideas please ?

Added on Apr 15 2019

4 comments

1,598 views