ora-29913 kup-04076 External error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ora-29913 kup-04076 External error

  1. #1
    Join Date
    Dec 2001
    Baltimore, MD

    ora-29913 kup-04076 External error

    Microsoft Windows XP [Version 5.1.2600]
    (C) Copyright 1985-2001 Microsoft Corp.


    SQL*Plus: Release - 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
    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:
    ORA-06512: at "SYS.ORACLE_LOADER", line 14
    ORA-06512: at line 1

    Can any provide me with a solution please?
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Sep 2002
    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

  3. #3
    Join Date
    Sep 2017
    you can try by giving the directory name as below

    " location(created_dir_name:'alert_vault.log')"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width