Hello all,
In Oracle 19.3 the DATA_PUMP_DIR worked with no issues when their was a space in the folder path
(Ex C:\Users\john doe\DataPump) , in version 21.3 it does not work when there is a space in the path.
To Update Oracle Path , I would drop to dos and start sqlplus as sysdba an execute the command
CREATE OR REPLACE DIRECTORY "DATA_PUMP_DIR" as 'C:\Users\John Doe\Documents\DataPump';
When I go to dos and try an import or an export it fails with the error
Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation: path traverses a symlink [29433]
I have validated the user has full control over the path, but no luck
I then change the DATA_PUMP_DIR to a folder path that has no spaces in it and it works.
Is there any workaround in 21.3 the make this work so the path with the space in it can be used