Database Utilities (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center