ora-29913 kup-04076 External error
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\WINDOWS>sqlplus/nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Sat Sep 27 22:25:21 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/**** as sysdba;
Connected.
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
7 )
8 location('c:\oracle\admin\vault\bdump\alert_vault.log')
9 )
10 reject limit 1000
11 ;
Table created.
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:
c:\oracle\admin\vault\bdump\alert_vault.log
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1
Can any provide me with a solution please?
Thanks
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.