Gather table stats with CASCADE TRUE option.
VIJ.VIJ_ITEMS_D
Connect Using system user
->Verify last_analyzed
select * from dba_tables where table_name='VIJ_ITEMS_D'
From TOAD-->
BEGIN
dbms_stats.gather_table_stats(ownname=> 'VIJ', tabname=> 'VIJ_ITEMS_D', cascade=> TRUE);
END;
>Verify last_analyzed
select * from dba_tables where table_name='VIJ_ITEMS_D'
VIJ.VIJ_ITEMS_D
Connect Using system user
->Verify last_analyzed
select * from dba_tables where table_name='VIJ_ITEMS_D'
From TOAD-->
BEGIN
dbms_stats.gather_table_stats(ownname=> 'VIJ', tabname=> 'VIJ_ITEMS_D', cascade=> TRUE);
END;
>Verify last_analyzed
select * from dba_tables where table_name='VIJ_ITEMS_D'