Slow "DATA IMPORT" Using SQL Developer When Table Does Not Exist Against Remote Database (Doc ID 3036039.1)

Last updated on JULY 22, 2024

Applies to:

Symptoms

On : 23.1.1 version, SQL Developer on Windows

You have a csv file of about 500K rows that you are using SQL Developer to load into a test able. The MacOS version of SQL Developer uploads the file in under 1 minute. On a Windows version of the same SQL Developer tool it takes 45 mins to upload the file.
All import settings are the same. 

Further testing reveals a difference in the IMPORT process.

1. IMPORT of the file into the database where a table does NOT exist is slow. That is, import tool takes table name and column information and then proceeds to create the table then loads the data - This is SLOW.

2. IMPORT of the same file , but into an existing empty table loads the records quicker.

3. The slowness occurs against a remote database, but imports quickly against local database.

Expected Behavior:

You expect similar import times, regardless of platform or whether the table exists or not..


STEPS
The issue can be reproduced at will with the following steps:

Without existing table:
Right-mouse-click on Tables under "schema" connection
Select "Import Data".
Select "Local File"filename.csv and select all defaults.
Set limit to 50000 rows/records.
Monitor time.

Repeat same steps with existing table.
Monitor time.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.