Sample Header Ad - 728x90

Expecting "," or ")", found "nvarchar2"

-1 votes
1 answer
154 views
Here is my SQL*Loader: Release 11.2.0.2.0 - Production on Fri Nov 10 00:39:56 2023 OS=UBUNTU 20 I am trying to load data from csv file with the help of following code: OPTIONS (SKIP=1) LOAD DATA INFILE '/home/oracle/airports.csv' INTO TABLE airportDemoData fields terminated by ',' optionally enclosed by '"' ( country nvarchar2(48), country_code varchar2(2), city nvarchar2(48), city_code varchar2(3), airport nvarchar2(84), airport_code varchar2(3) ) Here is sample of my csv file:
CSV FILE Here is my sqlldr command running in oracle user: sqlldr login/pass control=airport.ctl LOG=airport.log
Here is the error that I am facing:
SQL*Loader: Release 11.2.0.2.0 - Production on Fri Nov 10 00:39:56 2023 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. SQL*Loader-350: Syntax error at line 7. Expecting "," or ")", found "nvarchar2". country nvarchar2(48), ^ Please help me to point out where I am making mistake Best Regards
Asked by Java_Beginner (1 rep)
Nov 9, 2023, 09:25 PM
Last activity: Nov 9, 2023, 09:57 PM