Load on Table

guptae · Posted: Mon Sep 08, 2008 7:37 pm

Hello All,

My tablespace TS001 contain two tables A & B . I tried to load resume both the table simutaniously so table A loaded & for table B job i got the error that utility is not compatablw wth table A load utility.

I startforce the tablespace TS001 & Indexspace of table B & terminate the laod table B utility.Now when i am trying to load the table b again its showing 00C90206 ( Data inconsistant).

Now could you please tell how i can run load for table B

murmohk1 · Posted: Tue Sep 09, 2008 9:41 am

Ekta,

Since you terminated the load utiltiy, verify the TS. Is it in RECP? Also run CHECK DATA to see the data inconsistencies.

guptae · Posted: Tue Sep 09, 2008 12:29 pm

Hello Murali,

Thanks for your suggestion
But i already startforce the ts & IX so it would nt work. Now i drop the table & created it in differnt ts.