Skip to Main Content

SQL Developer

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.

Sql Developer freezes when trying to generate insert scripts from a CSV file.

stomOct 16 2020

Sql Developer freezes when trying to generate insert scripts from a CSV file. I was able to replicate this a few times.
Sql Developer version: 20.2
Database: 12.2.0.1
OS: Windows 10

  1. Open SQL Developer and connect to the database.
  2. On the object list tree, navigate to the target table.
  3. Right click and select import data.
  4. Select csv file.(file has 7 rows)
  5. Choose import method as Insert Script, Next, Next and Finish
  6. I get a popup saying "Import Data. Task successful and import committed."
  7. Click on Ok. This opens a worksheet with the insert scripts.
  8. All good so far. I see the data isn't inserted and there are no uncommitted transactions.
  9. Repeat steps 3 to 5 on the same table with the same or different csv, SQL Developer freezes.

It becomes unresponsive and I can't close it. I have to kill it from the task manager.

Attaching the jstack output.
jstack_output.txt (24.65 KB)

This post has been answered by stom on Jan 26 2021
Jump to Answer

Comments

Post Details

Added on Oct 16 2020
3 comments
1,458 views