You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Import data by oracle sql develper

edited Aug 6, 2018 11:26AM in Database 2 comments

Summary

Error importing 1.000.000 of rows (csv type)

Content

I am currently testing Oracle exadata express and i am currently working with Oracle sql developer app.

After loading a schema (migration from mysql) I would like to import data to the oracle database. To do that purpose I have all the tables in csv format and i use oracle sql developer to connect to the database.

When i try to import the data (1Milion rows) of a table it shows me an error and it only inserts 11183 rows.

I am using linux and the error is displayed into the terminal where i have launched the sql developer app:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!