Re: Oracle 7 export and ORA-01502
- From: Kirtikumar Deshpande <kedeshpande@xxxxxxxxx>
- To: A.Bahar@xxxxxxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 22 Apr 2005 06:25:50 -0700 (PDT)
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@xxxxxxxxxxxxxxxxxxxxxx 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.
> --
> //www.freelists.org/webpage/oracle-l
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
