ora-29913 kup-04076 External error
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
SQL*Plus: Release 18.104.22.168.0 - Production on Sat Sep 27 22:25:21 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/**** as sysdba;
SQL> create table alertlog ( text varchar2(80) )
2 organization external (
3 type oracle_loader
4 default directory BDUMP
5 access parameters (
6 records delimited by newline
10 reject limit 1000
SQL> select * from alertlog where text like '%ORA-%';
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04076: file name cannot contain a path specification:
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1
Can any provide me with a solution please?
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
I think its telling you that you cant put a full path to the file in here, you need to copy that file to to a valid entry which can be seen from dba_directories
Click Here to Expand Forum to Full Width