Home » RDBMS Server » Server Utilities » previleges error (10.2)
previleges error [message #589642] Tue, 09 July 2013 06:42 Go to next message
guddu_12
Messages: 227
Registered: April 2012
Location: UK
Senior Member
Hi,

I am using OWB to load a table which write sql loader command.
When running the load i am getting below error.

SQL*Loader-643: error executing INSERT statement for table "STG_EWORK"."STG_ISF_LUCC"

I am unable to guess which privileges is missing.

My control file as below
OPTIONS (SKIP=2,BINDSIZE=50000,ERRORS=0,ROWS=200,READSIZE=65536)
LOAD DATA
  CHARACTERSET WE8MSWIN1252
  INFILE '\\devora003.dev.tfl.local\PDW\PDW_Source\ISF_LUCC_Loadfile.csv' 
  CONCATENATE 1
INTO TABLE "STG_EWORK"."STG_ISF_LUCC"
  TRUNCATE
  REENABLE DISABLED_CONSTRAINTS
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' 
(
"STG_LOAD_DELTA_ID" EXPRESSION "FUNC_GET_DELTA_ID('MAP_STG_ISF_LUCC_TIN')",
"STG_LOAD_DATE" EXPRESSION "FUNC_GET_DELTA_DATE('MAP_STG_ISF_LUCC_TIN')",
"ISFNUMBER" POSITION(1) CHAR(15) "trim( :\"ISFNUMBER\" )" ,
"LUCC_CODE" CHAR(5) "trim( :\"LUCC_CODE\" )" 
)


Please let me know
Re: previleges error [message #589648 is a reply to message #589642] Tue, 09 July 2013 07:07 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Please copy and paste the whole session so we can see what happened.
Re: previleges error [message #589651 is a reply to message #589648] Tue, 09 July 2013 07:17 Go to previous messageGo to next message
guddu_12
Messages: 227
Registered: April 2012
Location: UK
Senior Member

Please see below

MAP_STG_ISF_LUCC_TIN
Error
RPE-01013: SQL Loader reported error condition, number 1.

SQL*Loader: Release 10.2.0.3.0 - Production on Tue Jul 9 12:32:24 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Control File:   \\devora003.dev.tfl.local\PDW\PDW_Working\Control\isf_lucc.ctl
Character Set WE8MSWIN1252 specified for all input.

Data File:      \\devora003.dev.tfl.local\PDW\PDW_Source\ISF_LUCC_Loadfile.csv
  Bad File:     \\devora003.dev.tfl.local\PDW\PDW_Working\Control\ISF_LUCC_Loadfile.bad
  Discard File:  none specified
 
 (Allow all discards)

Number to load: ALL
Number to skip: 2
Errors allowed: 0
Bind array:     200 rows, maximum of 50000 bytes
Continuation:   Concatenate every 1 physical records
Path used:      Conventional

Table "STG_EWORK"."STG_ISF_LUCC", loaded from every logical record.
Insert option in effect for this table: TRUNCATE

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
"STG_LOAD_DELTA_ID"                                       EXPRESSION
    SQL string for column : "FUNC_GET_DELTA_ID('MAP_STG_ISF_LUCC_TIN')"
"STG_LOAD_DATE"                                           EXPRESSION
    SQL string for column : "FUNC_GET_DELTA_DATE('MAP_STG_ISF_LUCC_TIN')"
"ISFNUMBER"                             1    15   ,  O(") CHARACTER            
    SQL string for column : "trim( :"ISFNUMBER" )"
"LUCC_CODE"                          NEXT     5   ,  O(") CHARACTER            
    SQL string for column : "trim( :"LUCC_CODE" )"

SQL*Loader-643: error executing INSERT statement for table "STG_EWORK"."STG_ISF_LUCC"
ORA-01031: insufficient privileges

SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

Table "STG_EWORK"."STG_ISF_LUCC":
  0 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Space allocated for bind array:                   5200 bytes(200 rows)
Read   buffer bytes:   65536

Total logical records skipped:          2
Total logical records read:             9
Total logical records rejected:         0
Total logical records discarded:        0

Run began on Tue Jul 09 12:32:24 2013
Run ended on Tue Jul 09 12:32:25 2013

Elapsed time was:     00:00:00.27
CPU time was:         00:00:00.07

SQL*Loader: Release 10.2.0.3.0 - Production on Tue Jul 9 12:32:24 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL*Loader-643: error executing INSERT statement for table "STG_EWORK"."STG_ISF_LUCC"
ORA-01031: insufficient privileges
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

Re: previleges error [message #589655 is a reply to message #589651] Tue, 09 July 2013 07:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have not the privilege to load this table.

Regards
Michel
Re: previleges error [message #589656 is a reply to message #589655] Tue, 09 July 2013 08:00 Go to previous message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Whichever user you're using to log SQL Loader into the database (which we don't know as you haven't shown us) does not have privileges on the table.
Previous Topic: Import a Flat File into Oracle and update another table
Next Topic: Location of SQL*Loader required
Goto Forum:
  


Current Time: Thu Mar 28 17:13:42 CDT 2024