Direct path not working with SQL*Loader of Instant Client 19.19 for Windows x64
>sqlldr userid=** * control=import.ctl direct=y
SQL*Loader: Release 19.0.0.0.0 - Production on Mon Jul 10 10:25:11 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2023, Oracle and/or its affiliates. All rights reserved.
Path used: Direct
==>no further output, empty logfile, nothing imported
Same using Conventional path:
SQL*Loader: Release 19.0.0.0.0 - Production on Mon Jul 10 11:52:16 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2023, Oracle and/or its affiliates. All rights reserved.
Path used: Conventional
Commit point reached - logical record count 1
Table XMLIMPORT:
1 Row successfully loaded.
Check the log file:
import.log
for more information about the load.
Or using Release 12.2 Full Client:
SQL*Loader: Release 12.2.0.1.0 - Production on Mo Jul 10 11:47:16 2023
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.