Hmmmm....18c works fine, but 19 does not
C:\>sqlldr userid=scott/tiger@db18_pdb1 control=\\gtx\c$\temp\dept.ctl data=\\gtx\c$\temp\dept.dat log=\\gtx\c$\temp\dept.log bad=\\gtx\c$\temp\dept.bad errors=0
SQL*Loader: Release 18.0.0.0.0 - Production on Wed Nov 20 13:29:13 2019
Version 18.6.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Path used: Conventional
Commit point reached - logical record count 3
Commit point reached - logical record count 4
Table DEPT:
4 Rows successfully loaded.
Check the log file:
\\gtx\c$\temp\dept.log
for more information about the load.
versus
C:\>sqlldr userid=scott/tiger@db19_pdb1 control=\\gtx\c$\temp\dept.ctl data=\\gtx\c$\temp\dept.dat log=\\gtx\c$\temp\dept.log bad=\\gtx\c$\temp\dept.bad errors=0
SQL*Loader-503: Error appending extension to file (\\gtx\c$\temp\dept.ctl)
SQL*Loader-567: unable to derive file name
SQL*Loader-509: System error: The operation completed successfully.
A workaround is to have true share names not the admin ones, eg
C:\>sqlldr userid=scott/tiger@db19_pdb1 control=\\gtx\c\temp\dept.ctl data=\\gtx\c\temp\dept.dat log=\\gtx\c\temp\dept.log
SQL*Loader: Release 19.0.0.0.0 - Production on Wed Nov 20 13:37:27 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Path used: Conventional
Commit point reached - logical record count 3
Commit point reached - logical record count 4
Table DEPT:
4 Rows successfully loaded.
Check the log file:
\\gtx\c\temp\dept.log
for more information about the load.
I'm asking around internally to see if there's a reason, or whether its a bug.