I'm trying to create a external table to make connection between Oracle and a CSV file.
But I always get error message as below.
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file I:\Oracle Data/[login to view URL]
29913. 00000 - "error in executing %s callout"
*Cause: The execution of the specified callout caused an error.
*Action: Examine the error messages take appropriate action.
I have already created a directory named DESKTOP and my query is as below.
CREATE TABLE Sample
( LAG VARCHAR2(1),
MARKET VARCHAR2(9),
ACTUAL_SHIPMENT_UNITS VARCHAR2(5))
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY DESKTOP
ACCESS PARAMETERS
(records delimited BY '\r\n'
BADFILE DESKTOP:'[login to view URL]'
NODISCARDFILE
LOGFILE DESKTOP:'[login to view URL]'
skip 1
fields terminated BY ','
OPTIONALLY ENCLOSED BY '"' AND '"'
lrtrim
missing field VALUES are NULL
( LAG CHAR(20),
MARKET CHAR(20),
ACTUAL_SHIPMENT_UNITS CHAR(20)
)
)
LOCATION ('[login to view URL]')
)
REJECT LIMIT UNLIMITED;
SELECT * FROM SAMPLE;
Based on my preliminary analysis based on the log and error I am sure it's related to virtual/physical directory path which the OS may not be able to access, I can do that after having process access.
Relevant Skills and Experience
I have 6 years of experience in Design, Development, Testing and Implementation on Oracle 11i and R12. It won't be an issue while working on.
Proposed Milestones
$25 USD - After the acceptance of bid can deliver the working code in 3 days.
I can fix this immediately, we can have the discussion about the same in details if required.
$25 USD 1 päivässä
5,0 (1 arvostelu)
0,8
0,8
11 freelancers are bidding on average $25 USD for this job
As Oracle DBA have gone through the issue being faced and understand the SQL loader file that you have copied here
Relevant Skills and Experience
SQL Loader,Oracle
Proposed Milestones
$25 USD - Solving
Could we please share a remote session or give me the desired results to understand and troubleshoot
I am not sure about the problem but I can try somethings to get. I need more information about your system
Relevant Skills and Experience
I have worked on Oracle but I wasn't a DB admin or something like that.
Proposed Milestones
$15 USD - Complete Solution
What OS do you use?