Sql Loader Direct NFS Warning Messages While Loading Data With CHARACTERSET "JA16SJIS"
Last updated on MARCH 21, 2016
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
Getting Sql Loader Direct NFS warning messages while loading data with CHARACTERSET "JA16SJIS" and the Data Source file location is on NFS.
The used Sql Loader Control file is like:
LOAD DATA CHARACTERSET "JA16SJIS"
INTO TABLE FCYT_SYUKUJITU_M
FIELDS TERMINATED BY "|"
OPTIONALLY ENCLOSED BY '"'
Next Direct NFS warning messages are raised when using CHARACTERSET "JA16SJIS":
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
::Warning message CHARACTERSET "JA16SJIS"::
Path used: Conventional
Direct NFS: channel id  path [tkgisnap061-v101.nomura.com] to filer [tkgisnap061-v101.nomura.com] via local  is UP
Direct NFS: attempting to mount /vol/vol101/nap061gis_userhome1/srenair on filer tkgisnap061-v101.nomura.com defined in mtab
Direct NFS: channel config is:
channel id  local  path [tkgisnap061-v101.nomura.com]
 kgnfs_exec_remote_mount:2430: warn could not spawn oradism
Direct NFS: please check that oradism is setuid
Commit point reached - logical record count 1
1 Row successfully loaded.
If CHARACTERSET is "UTF8" in the sqlldr controlfile, there is no warning message.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms