Puja Shaw
Reputation: 145
Importing 3 million records from csv to oracle DB table
I am trying to import 3 million rows from a csv file to DB table using sql developer import wizard, but getting below error every time when it reaches 12k rows . When I tried importing only 100 rows from the same file, it inserted successfully. Please help me with the error.
error screenshot:
File screenshot:
Upvotes: 0
Views: 515
Answers (0)
Related Questions
- import csv file into table using SQL Loader [but large no. of Columns]
- Reading A Massive CSV file into an Oracle table
- How to import millions of records from flat file to oracle table
- SQL import 10000+ .csv files
- import data from file csv to Oracle using sql
- Best way to import a large dataset into Oracle sql database?
- What is the best way to update more than 1 million rows in a table in Oracle using a CSV file
- Best way to export huge data from Oracle DB to Oracle DB
- Importing 360,000 rows into a Global Temporary Table
- Fast way to load over a billion rows into Oracle from text files