Index Issue In Oracle

BillB · Post by **BillB** » Tue May 13, 2008 7:01 pm

While loading the data in to oracle using oracle enterprise stage having properties disable constraints true and index rebuild, running

Giving the following warning.

LA_BMS_9999999_104: When checking operator: There are no indexes on table `BMS_9999999_104', and an index option was included;
the index option will be ignored.

Even though the index was dropped and recreated.

Any suggestion to fix this?

Thanks

keshav0307 · Post by **keshav0307** » Tue May 13, 2008 10:45 pm

if you run this query

select * from ALL_INDEXES WHERE TABLE_NAME='BMS_9999999_104'

does it return any row?

BillB · Post by **BillB** » Mon May 19, 2008 5:33 pm

Running the jobs with Disable Constraint False as workaround