2 Replies Latest reply: Oct 1, 2013 8:04 AM by 28f0f31d-f7f8-4fcd-a737-4d97bf31ab13 RSS

    Errors: ORA-29913 ORA-29400 KUP-03154, when executing SEM_APIS.LOAD_INTO_STAGING_TABLE

    28f0f31d-f7f8-4fcd-a737-4d97bf31ab13

      Hi all,

       

      I use Oracle 12c Spatial and Graph and I need to load a N-QUAD file with large literals.


      To do so I first create a directory and a source external table

       

      SQL> CREATE DIRECTORY DATA_DIR AS '/tmp';

      SQL> EXECUTE sem_apis.create_source_external_table(source_table => 'STAGE_TABLE_SOURCE', def_directory => 'DATA_DIR', bad_file => 'CLOBrows.bad');

      SQL> ALTER TABLE "STAGE_TABLE_SOURCE" LOCATION ('data.nq');

       

      then I change the READSIZE parameter of the external table (because the literals of the file are more than 512KB).

       

      SQL> ALTER TABLE STAGE_TABLE_SOURCE DEFAULT DIRECTORY DATA_DIR ACCESS PARAMETERS (READSIZE 1048576);

       

      the I try to load data into the staging table

       

      SQL> EXECUTE SEM_APIS.LOAD_INTO_STAGING_TABLE(staging_table => 'STAGE_TABLE', source_table  => 'STAGE_TABLE_SOURCE', input_format  => 'N-QUAD');

       

      but I get the following error:

      ERROR at line 1:

      ORA-13199: During LST: SQLERRM=ORA-29913: error in executing ODCIEXTTABLEOPEN

      callout

      ORA-29400: data cartridge error

      KUP-03154: kudmxo-03:invalid_dump_header

      (Arguments:  staging_table=STAGE_TABLE source_table=STAGE_TABLE_SOURCE

      input_format=N-QUAD parallel= source_table_owner= staging_table_owner= flags=)

      [ORA-06512: at "MDSYS.SDO_RDF", line 884

      ]

      ORA-06512: at "MDSYS.MD", line 1723

      ORA-06512: at "MDSYS.MDERR", line 17

      ORA-06512: at "MDSYS.SDO_RDF", line 906

      ORA-06512: at "MDSYS.RDF_APIS", line 883

      ORA-06512: at line 1

       

      I could not find any information about error KUP-03154.

      Any hint about how to solve this problem will be very appreciated.