Ora-29913 Error In Executing Odciexttableopen Callout Kup-04063
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please can we create index on external table in oracle type your message and try again. More discussions in PL/SQL and SQL All PlacesDatabaseDatabase
Ora-29400 Data Cartridge Error Kup-04040
Application DevelopmentPL/SQL and SQL This discussion is archived 12 Replies Latest reply on Sep 18, 2010 11:43 AM by user8731258 ORA-29913: error ora-29913: error in executing odciexttableopen callout ora-29400: data cartridge error in executing ODCIEXTTABLEOPEN callout user8731258 Sep 17, 2010 11:27 AM create table external (empno number(4), ename varchar2(10), job varchar2(9), mgr number(4), hiredate date, sal number, comm number, deptno number(2) ) organization external (type oracle_loader default oracle external table directory data_dir access parameters (fields terminated by ',') location('emp.dat') ) / table createdBut when i run the statement sql>select count(*) from external;i get an error {error} ERROR at line 1: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-04063: unable to open log file EXTERNAL_4295.log OS error No such file or directory ORA-06512: at "SYS.ORACLE_LOADER", line 19 {error} I have the same question Show 0 Likes(0) 3180Views Tags: none (add) 10gContent tagged with 10g This content has been marked as final. Show 12 replies 1. Re: ORA-29913: error in executing ODCIEXTTABLEOPEN callout MaheshKaila Sep 17, 2010 11:35 AM (in response to user8731258) 1) Create table with below script CREATE TABLE EXTERNAL ( EMPNO NUMBER(4), ENAME VARCHAR2(10 CHAR), JOB VARCHAR2(9 CHAR), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER, COMM NUMBER, DEPTNO NUMBER(2) ) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY data_dir ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY ',' ) LOCATION (data_dir:'emp.dat') )2) Put emp.dat on data_dir directory. Regards, Mahesh Kaila Edited by: Mahesh Kaila on Sep 17, 2010 5:05 PM Like Show 0 Likes(0) Actions 2. Re: ORA-29913: error in executing ODCIEXTTABLEOPEN callout user8731258 Sep 17, 2010 11:54 AM (in response to MaheshKaila) I did that.. yet i got the same error.. i have put the emp.dat file on the server... Like Show 0 Likes(0) Actions 3. Re: ORA-29913: error in executing ODCIEXTTABLEOPEN callout Saubhik Sep 17, 2010 12:07 PM (in response to user8731258) What is the definition of your data_dir? Use ALL_DIRECTORIES and show the output. Like Show 0 Likes(0) Actions 4. Re: ORA-29913: error in executing ODCIEXTTABLEOPEN callout user8731258 Sep 17, 2
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Export/Import/SQL Loader & External Tables All PlacesDatabaseOracle Database + OptionsExport/Import/SQL Loader & External Tables This discussion is archived 1 2 Previous Next 23 Replies Latest reply on Jan 30, 2011 5:14 PM by 835401 Go to original post This content has been marked as final. Show 23 replies 15. Re: external tables Jens Petersen Sep 21, https://forums.oracle.com/thread/1132489 2005 12:31 PM (in response to 450558) Step 1;created a directory physically in theserver at a location contentAt which location? and then copied the file which has the what's the name of the file? Like Show 0 Likes(0) Actions 16. Re: external tables Kamal Kishore Sep 21, 2005 12:34 PM (in response to shishu) We have tried the command and after that received the reutrn that directory created https://community.oracle.com/thread/330047?start=15&tstart=0 but unable to find the directory on specified PC.This is not the command to create a physical directory on the file system of your operating system on which Oracle server is running. This command will NOT create a directory on your file system. You would have to create that with the opearting system tools (like mkdir). The create directory is a database object that is just a mapping to the physical directory on disk. Message was edited by: Kamal Kishore Like Show 0 Likes(0) Actions 17. Re: external tables Nicolas.Gasparotto Sep 21, 2005 1:19 PM (in response to 450558) Ok, this is all the manip for you. SQL> conn / as sysdba Connected. SQL> create or replace directory DATA_FILE_DIR2 as 'E:\oracle\ora92\demo\schema\sales_history\'; --don't forget the last \ Directory created. SQL> grant read on directory DATA_FILE_DIR2 to scott; Grant succeeded. SQL> grant write on directory DATA_FILE_DIR2 to scott; Grant succeeded. SQL> conn scott/***** Connected. SQL> CREATE TABLE EMP_TRY_1 2 ( 3 PROD_ID NUMBER(6), 4 CUST_NAME VARCHAR2(100), 5 SAL NUMBER(3) 6 ) 7 ORGANIZATION EXTERNAL 8 ( TYPE ORACLE_LOADER 9 DEFAULT DIRECTORY DATA_FILE_DIR2 10 ACCESS PARAMETERS 11 ( RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII 12 BADFILE log_file_dir:'sh_sales_ext.
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=37052 PLSQL Oracle Applications Papers Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation http://stackoverflow.com/questions/9066191/sqlplus-error-on-select-from-external-table-ora-29913-error-in-executing-odcie Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All threads | Best last month | error in Question Most of my databases are on version 12.1 11.2 11.1 10.2 10.1 or lower Answer and see the results DBA Top 10 1 M. Cadot 35800 2 F. Diaz 34000 3 J. Schnackenberg 16400 4 B. Vroman 15450 5 A. Kavsek 15250 6 P. Wisse 14250 7 T. Boles 13500 8 M. Hidayathullah ... 10900 9 A. Hudspith 9200 10 A. Khan 4100 error in executing About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47788Total active users2117Act. users last 24h9Act. users last hour1Registered user hits last week756Registered user hits last month6432 Go up Problem on external table Next thread: how to schedule procedures by sys/user Prev thread: DBMS_STATS.GATHER_SHEMA_STATS/ ORA-20000: Insufficient privileges to analyze an object in Schema Message Score Author Date Hello, I have created an directory,given read w...... kishaloy nag Jun 25, 2009, 05:58 Hi kishaloy nag, Is the directory on the same s...... Louis Ywema Jun 25, 2009, 07:53 yes on both counts,I tried recreating the ext tabl...... kishaloy nag Jun 25, 2009, 08:19 the data file with that name does not exist Reg...... Alessandro Deledda Jun 25, 2009, 09:50 hello The exact file name is present in the dir...... kishaloy nag Jun 25, 2009, 09:52 High, when you give a 766 on a directory, it mean...... Paul Vring Jun 25, 2009, 10:14 Hello, I have done 777 for all the directories ...... kishaloy nag Jun 25, 2009, 10:18 What are the permissions
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up sqlplus error on select from external table: ORA-29913: error in executing ODCIEXTTABLEOPEN callout up vote 4 down vote favorite 1 I have setup a simple Oracle external table test that I (alongside a DBA and Unix admin) can't get to work. The following is based on Oracle's External Tables Concepts. The database we're using is 11g. This is the external table definition: drop table emp_load; CREATE TABLE emp_load (employee_number CHAR(5), employee_dob DATE, employee_last_name CHAR(20), employee_first_name CHAR(15), employee_middle_name CHAR(15), employee_hire_date DATE) ORGANIZATION EXTERNAL (TYPE ORACLE_LOADER DEFAULT DIRECTORY defaultdir ACCESS PARAMETERS (RECORDS DELIMITED BY NEWLINE FIELDS (employee_number CHAR(2), employee_dob CHAR(20), employee_last_name CHAR(18), employee_first_name CHAR(11), employee_middle_name CHAR(11), employee_hire_date CHAR(10) date_format DATE mask "mm/dd/yyyy" ) ) LOCATION ('external_table_test.dat') ); This is the contents of "external_table_test.dat": 56november, 15, 1980 baker mary alice 09/01/2004 87december, 20, 1970 roper lisa marie 01/01/1999 I am able to run the script that creates "emp_load" with no issues. I can also describe the table fine. When I attempt "select * from emp_load", I get the following errors: SQL> select * from emp_load; select * from emp_load * ERROR at line 1: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error error opening file /defaultdir/EMP_LOAD_29305.log EDIT 1 oracle has read/write permissions on the