0 Replies Latest reply on Jun 11, 2008 10:57 PM by 644581

    Problem on Load the n-triples into staging table with sqlploader

    644581
      Hi,

      I try to run biopax.sql to load biopax.nt into the database and then several problems appear. My operation system is Windows XP, so I do some modification on commands. Here is the input and output:

      Input:
      -- Load the n-triples into staging table with sqlploader

      host D:\app\product\11.1.0\db_1\bin\sqlldr userid=biopax/biopax
      control=D:\app\product\11.1.0\db_1\md\demo\network\rdf_demos\bulkload.ctl data=D:\Ontology\biopax.nt direct=true skip=0
      load=1000000 discardmax=0 bad=d0.bad discard=d0.rej log=d0.log errors=100000000

      Output:

      control=


      Then I try to input the control again:

      control = D:\app\product\11.1.0\db_1\md\demo\network\rdf_demos\bulkload.c
      tl

      Now the output is:

      SQL*Loader: Release 11.1.0.6.0 - Production on Wed Jun 11 15:53:02 2008

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

      SQL*Loader-268: UNRECOVERABLE keyword may be used only in direct path.

      SP2-0734: unknown command beginning "control=D:..." - rest of line ignored.
      SP2-0734: unknown command beginning "load=10000..." - rest of line ignored.

      Grant succeeded.


      Grant succeeded.


      PL/SQL procedure successfully completed.


      no rows selected


      no rows selected



      Would you please help me and tell me what the wrong is in my implementation.

      Thanks a lot and best wishes.

      Yours sincerely

      Leo