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@(protected) 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 (See ORA-01502.ora-code.com): 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
