Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    Oracle message in alert log: "performing DML/DDL operation over object in bin"

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 19.01

    Description:
    We started seeing the following messages in the alert log on our production server early this morning:

    Mon May 24 04:00:07 2010
    performing DML/DDL operation over object in bin.
    Mon May 24 04:00:12 2010
    performing DML/DDL operation over object in bin.

    Also, we saw the following in this morning's run of clear_vir01:

    aleph_admin@ALEPH1> 04:00:12 aleph_admin@ALEPH1> DROP TABLE VIR01.Z52
    *
    ERROR at line 1:
    ORA-38301: can not perform DDL/DML over objects in Recycle Bin


    Elapsed: 00:00:00.00
    CREATE TABLE VIR01.Z52 (
    *
    ERROR at line 1:
    ORA-00955: name is already used by an existing object


    Elapsed: 00:00:00.01
    04:00:12 aleph_admin@ALEPH1> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Deleting statistics .....
    mv /exlibris/aleph/a19_1/vir01/files/z52.seqaa
    /exlibris/aleph/a19_1/vir01/files/z52.seq
    table_type = FIX load_mode = DIRECT option = go Loading Table : z52 table_type = FIX option=go *******table_type == FIX ==************************** Converting a FIX Input File into a Delimited File
    /exlibris/aleph/a19_1/aleph/proc/p_file_11
    VIR01,T,z52,/exlibris/aleph/a19_1/vir01/files/z52.seq,/exlibris/aleph/a19_1/vir01/files/z52.comp.seq,VIR01
    [2J [H [0m
    ALEPH/SUN_OS_2, Copyright Ex Libris.
    version 19 revision 01 copy 1, 24-Dec-2007

    SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 24 04:00:13 2010

    Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

    vir01@ALEPH1> > > > > 2 0
    0
    NO COLUMNS FOUND FOR TABLE
    No errors.
    1* begin f1_Z52; end;
    2 NO COLUMNS FOUND FOR TABLE
    No errors.
    1* begin f2_Z52; end;
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
    in_fl: /exlibris/aleph/a19_1/vir01/files/z52.seq out_fl:
    /exlibris/aleph/a19_1/vir01/files/z52.comp.seq
    Error: can't write to file
    compress_seq_file /exlibris/aleph/a19_1/vir01/scratch/z52.length
    /exlibris/aleph/a19_1/vir01/files/z52.seq
    /exlibris/aleph/a19_1/vir01/files/z52.comp.seq

    SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 24 05:14:15 2010

    Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

    vir01@ALEPH1> vir01@ALEPH1> > > > > > > 2 LOAD DATA
    INFILE '$data_files/z52.comp.seq'
    No errors.
    1* begin l1_Z52 ('DLM2'); end;
    2 BADFILE '$data_scratch/z52.bad'
    APPEND
    No errors.
    1* begin l2_Z52 ('DLM2'); end;
    2 INTO TABLE VIR01.Z52
    FIELDS TERMINATED BY X'09'
    (
    NO COLUMNS FOUND FOR TABLE
    )
    No errors.
    1* begin l3_Z52 ('DLM2'); end;
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options table_type = FIX load_mode = DIRECT option = go
    Username:SQL*Loader-350: Syntax error at line 8.
    Expecting "," or ")", found "COLUMNS".
    NO COLUMNS FOUND FOR TABLE
    ^

    SQL*Loader: Release 10.2.0.4.0 - Production on Mon May 24 05:14:15 2010

    Copyright (c) 1982, 2007, Oracle. All rights reserved.

    VIR01 index z52
    l_op == index
    l_table == z52

    SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 24 05:14:16 2010

    Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

    Enter user-name:
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

    aleph_admin@ALEPH1> 05:14:16 aleph_admin@ALEPH1> CREATE UNIQUE INDEX VIR01.Z52_ID ON VIR01.Z52 (Z52_REC_KEY ASC)
    * ERROR at line 1:
    ORA-01408: such column list already indexed


    Elapsed: 00:00:00.00
    05:14:16 aleph_admin@ALEPH1> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Deleting statistics .....
    Wrote Z100 record with rec-key: 000000367

    Oracle error: io_z52_update
    ORA-38301: can not perform DDL/DML over objects in Recycle Bin

    get_print_file_name : VIR01.z52.last-file-number does not exist.
    Creating entry with default values.

    Oracle error: io_z52_write
    ORA-38301: can not perform DDL/DML over objects in Recycle Bin

    get_print_file_name : ERROR - Could not create new z52 entry

    I/O error : file ''
    error code: 9/004 (ANS74), pc=0, call=1, seg=0
    4 Illegal file name

    end

    END: clear_vir01

    Resolution:
    As described in KB 16384-913, either purge the vir01 recyclebin on a regular basis or turn it off.

    • Article last edited: 10/8/2013