CSV FILE CONTENT
portal,,
ex portal,,
,,
i_id,i_name,risk
1,a,aa
2,b,bb
3,c,cc
4,d,dd
5,e,ee
6,f,ff
7,g,gg
8,h,hh
9,i,ii
10,j,jj
CONTROL FILE CONTENT
options (
skip=4,
PARALLEL=true,
DIRECT=true
)
LOAD DATA
INFILE 'E:\sqlloader\testfile.csv'
APPEND
INTO TABLE LOADER_TAB
FIELDS TERMINATED BY ","
(
i_id,
i_name,
risk
)
I am getting invalid username password in command prompt while using sqlldr command but able to login in SQL developer. Please find the screenshot below
Object does exist in TAM user
2, Able to insert a record into this table
3, When I am trying sqlldr with same username and password it is giving invalid username or password. I had tried by creating new user as well but still it says the same
4, Now, I have changed the password
alter user tam identified by tiger111;
5, It throws an error and haven't processed
