A
anzeljamal
Guest
I have a table which has a field with datatype date with initial value set as ?. I have added some records into the table and some of the records have the date field value as ?. Later on i have made the date field as mandatory and added a unique index with one component being this date field. I have rebuild the indexes and i didnt get any error while doing the same. The index rebuild completed without any errors. After that i have added more records into the table. Then i am adding a new index to the table which doesnt have any reference to this date field. But when i loads the df i am getting an error as " ** . Date-field is mandatory, but has unknown value(?) value (110) ". I have tried to query the record with ?, but couldnt find any records as such. I think it is because of the unique index already present for the field and while rebuilding that index, the record would have not been entered in the index table. So i deactivated all the indexes of the table and enabled just one index, and tried to fetch the data, and i am able to find one record with that date filed value as ?. I have updated it directly and enabled all the indexes and again tried to load the same df, but still i got the same error. Can any one please suggest what is the issue here? And a solution to overcome a scenario like this ? Will adding a new index rebuilds all the unique indexes of the table ?
Continue reading...
Continue reading...