1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Executing error

Discussion in 'SQL PL/SQL' started by pkiran, Sep 1, 2015.

  1. pkiran

    pkiran Newly Initiated

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    40
    Location:
    newyork
    when iam trying to execute the shell script to load the sql data I am geeting like this could you guys please help me in this.
    ORA-39776: fatal Direct Path API error loading table 'servername'."tablename"
    ORA-26026: unique index 'servername.U_tablename' initially in unusable state
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,346
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    The last error message says it all:

    ORA-26026: unique index 'servername.U_tablename' initially in unusable state

    I can only presume these names are NOT the names of the actual objects. You need to rebuild the index:

    alter index servername.U_tablename rebuild;

    This could take a while but it is absolutely necessary for you to load any more data into this table.
     
    sunil likes this.
  3. pkiran

    pkiran Newly Initiated

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    40
    Location:
    newyork
    really thanks for the reply the mistake I did is, I executed the shell script twice for a same date which made the table to corrupt so I deleted the data for that date in the table and then I executed it.
    thanks murali for helping me in this.