Re: Oracle 7 export and ORA-01502

From: Kirtikumar Deshpande <kedeshpande_at_yahoo.com>
Date: Fri, 22 Apr 2005 06:25:50 -0700 (PDT)
Message-ID: <20050422132550.91373.qmail@web50103.mail.yahoo.com>

Arslan,

 The index is in unusable state, most likely due to a failed direct load using SQL*Loader. The index will need to be dropped or rebuilt first. The export will succeed then.

Cheers!

• Kirti
  • A.Bahar_at_billing-components.com wrote:
    > Hi ,=20
    > =20
    > I have not performed export for 5 years and after 5 years , it is =
    > the first time that I have connected and oracle 7 :).
    > =20
    > Exporting full database has produced following error.
    > =20
    > EXP-00008: ORACLE error 1502 encountered
    > ORA-01502: index 'BC11.BLCALLDT_BILL_RUN_SEQ_BI' is in direct load =
    > state
    >
    >
    > Do you have any idea ?
    >
    > Arslan.
    > --
    > http://www.freelists.org/webpage/oracle-l
    >
    

    ---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 22 2005 - 09:30:02 CDT