Skip to Main Content

SQL Developer for VS Code

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!

Importing data only works in own schema

When I try to perform a data import on another schema's preexisting table, I get a permissions error because it attempts to create a table in my own schema. It is using the “insert” import method (all the others are grayed out), and when I click “Save state” to save to an “sdimp” fie, I see it's clearly trying to import the data into my own schema instead of into the one I selected. When I edit the data import config file to use the right schema and save, then to re-run the wizard using this file (with the “Restore state” button), I encounter the same error:

This post has been answered by thatJeffSmith-Oracle on Jun 3 2026
Jump to Answer
Comments
Post Details
Added 5 days ago
2 comments
45 views