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!

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,680 views