Oracle External Table [message #435109] |
Mon, 14 December 2009 06:12 |
ramya29p
Messages: 146 Registered: November 2007 Location: Chennai
|
Senior Member |
|
|
Hi,
I tried to upload the Data through External Table.
SQL> create table ext_emp(ename varchar2(20),age number)
2 organization external(
3 type oracle_loader
4 default directory dir1
5 access parameters
6 (fields terminated by ','
7 )
8 location('emp.txt')
9 )
10 /
Table created.
SQL> desc ext_emp;
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
ENAME VARCHAR2(20)
AGE NUMBER
table got created but while selecting from the table i am getting the following error. can anyone please help me.
SQL> select * from ext_emp;
select * from ext_emp
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file EXT_EMP_2604_4584.log
|
|
|
|
|
|
|
|
|
Re: Oracle External Table [message #435121 is a reply to message #435119] |
Mon, 14 December 2009 07:12 |
|
Michel Cadot
Messages: 68643 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:But still i am getting the same problem.
Answer below:
Quote:2/ And you need to be sure that the instance owner has access to the directory and file.
Quote:"D:\BPEL" should be a directory on a database server, not your local PC. Is that the case?
Regards
Michel
[Updated on: Mon, 14 December 2009 07:13] Report message to a moderator
|
|
|
Re: Oracle External Table [message #435122 is a reply to message #435109] |
Mon, 14 December 2009 07:31 |
ramya29p
Messages: 146 Registered: November 2007 Location: Chennai
|
Senior Member |
|
|
sorry i created the path with my local pc directory.
After creating directory on a database server. i am getting the below error
select * from abc1
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-30653: reject limit reached
|
|
|
Re: Oracle External Table [message #435123 is a reply to message #435122] |
Mon, 14 December 2009 07:38 |
|
ramoradba
Messages: 2456 Registered: January 2009 Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
Quote:ORA-30653: reject limit reached
Cause: the reject limit has been reached.
Action: Either cleanse the data, or increase the reject limit.
And always search before posting.
Always add/provide your Oracle version with 4 digits along with your post.
Sriram
[Updated on: Mon, 14 December 2009 07:49] Report message to a moderator
|
|
|
|
|