DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: sqlldr failure

  1. #1
    Join Date
    Oct 2005
    Location
    Dallas
    Posts
    3

    sqlldr failure

    I am running Oracle 10g on a Sun V490/Solaris 10 platform. When I attempt to run sqlldr from the command line (see below for the top of the .ctl file) I get the following error;

    SQL*Loader-941: Error during describe of table VD_CLAIM
    ORA-04043: object VD_CLAIM does not exist

    I am logging into sqlldr as SYS, connecting as sysdba since the owner of the schema/table gets booted out as "invalid user/password". This is odd in that the user can log into the Enterprise Manager and isqlplus interfaces and perform all appropriate actions.

    I have looked up the error (04043) and it appears to be tied to privileges; but SYS has full privileges on the table VD_CLAIM.


    LOAD DATA
    INFILE '/export/medic/tape4/vendor/utd_clm.dat'
    INSERT
    INTO TABLE VD_CLAIM

    thanks for any help,

    Orwreckal

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you need to prefix the table with the schema name, how else would it know what schema it was in?

    but I would fix your problem with the username / password as using sys should be discouraged, guess you are doing something wrong somewhere
    whats the full sqlldr command you are issuing

  3. #3
    Join Date
    Oct 2005
    Location
    Dallas
    Posts
    3

    here is the sqlldr login

    Davey,

    Thank you. Below is the way I access sqlldr; this particular login works. However my other user MFAD cannot login as it gets the ora 04043 error "invalid user/password". This is very odd as this particular user can login into the enterprise manager and isqlplus interfaces.

    >sqlldr \' sys/xxxxx AS SYSDBA \'

    The system responds with

    >control=

    I enter the path/name of the control file and it begins to run and then ends with the following error;

    SQL*Loader-941: Error during describe of table MFAD.VD_LOCKIN
    ORA-04043: object MFAD.VD_LOCKIN does not exist

    MFAD is the user/schema name that works everywhere but sqlldr.

    Thanks for your assistance.

  4. #4
    Join Date
    Oct 2005
    Location
    Dallas
    Posts
    3

    full sqlldr .ctl file

    LOAD INFILE '/export/medic/tape4/vendor/utd_vd_lockin_2004_08.dat'
    INSERT
    INTO TABLE MFAD.VD_LOCKIN

    The ctl file explodes on the INTO TABLE line.

    thanks again,

    Orwreckall

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Check the BAD file for errors, as well see if the table has any non-portable data types. Since you are doing an INSERT are you sure the table is empty?
    "What is past is PROLOGUE"

  6. #6
    Join Date
    Nov 2003
    Posts
    89
    Check if you have that table in MFAD schema and grant insert permissions to sys and try it.

    I just tried with sys user and works fine with other schema tables.

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