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
    Location
    Baltimore, MD
    Posts
    374

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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
    Posts
    2
    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