Results 1 to 3 of 3

Thread: sqlloader

  1. #1
    Join Date
    May 2002
    Posts
    2

    Unhappy Unanswered: sqlloader

    i've got any problems launching a load to a oracle db because (i think) i'm trying to populate a table in a multistances oracle installation:

    istance: CLAIMNET schema: ECLAIMS table: PRATICA
    on a server called AMA1254_dbsrv

    in my .CTL file i wrote

    LOAD DATA
    INFILE 'c:/oracle/migrazione_assimoco/dati/S0002457.DAT'
    APPEND
    INTO TABLE eclaims.pratica

    and the error returned by SQLLOAD is...

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

    If anybody met the same problem .... HELP

  2. #2
    Join Date
    Apr 2002
    Posts
    17
    Have you checked the permissions for the user you are trying to perform the load as?

    Only thing I can think of offhand...

    Geoff.

  3. #3
    Join Date
    May 2002
    Posts
    2

    Talking sqlloader

    Thanks Geoff !!
    I solved the problem.
    It wasn't in the .ctl file but in the connection string invoking SQLLOADER...

    i modified it from

    Sqlldr userid=internal/oracle ......

    to

    Sqlldr userid=internal@claimnet/oracle ......

    so the launch works pointing the correct instance/schema/table.

    Arma

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •