That mean using exp/imp we can do direct right?You can't go direct to 11g from 8i (except using exp/imp)
I guess its 8.1.5Can you let us know your current Version of Oracle? 8.x.x.x
select owner, object_name, object_type, statusRegards,
where status != 'VALID';
I did that but still I am getting errors like complied with errors.. Is there any other way? or can we avoid this by using another parameter while importing time itself?Recreate the invalid synonyms.
Recompile the views, packages, functions, procedures, triggers,etc...
select owner, object_type, count(*)Regards,
where status = 'INVALID'
group by owner, object_type;