Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

SQLcl datapump import error

Plamen PetrovJun 8 2026

I am trying to import a dump using SQLcl 26.1.2 and I get an error:

SQL> dp import -d TMP_DIR -dd TMP_DIR -dumpfile pp_%U.dmp -ve true -v latest
Value DATA_PUMP_DIR is not valid for Parameter directory
DataPump: Unable to process request. Verify specified options:
Parameters
---------------------------------------------
---------------------------------------------
End Parameters

I don't use the DATA_PUMP_DIR, my account has read/write access to TMP_DIR. Looks like something is hardcoded in the dp command.

This post has been answered by Oussama Assouar-Oracle on Jun 8 2026
Jump to Answer
Comments
Post Details
Added on Jun 8 2026
1 comment
63 views