Invalid Objects in Performing Import

[vishywish]

HI All DBA's
I want to migrate from Oracle 7.x to Oracle 8i.I know that during the process of migration some of the objects become invalid.Will running catalog.sql solve the problem?What,in any case are the objects that become invalid.Any Suggestions?
Thanks in Advance
vishywish

[vicky]

Hi,

Before migration take a list of all valid objects by using following ...

1. select owner,object_name,status from
dba_objects where
status ='VALID';

2. select count(*) as VALID_OBJECTS from dba_objects
where status ='VALID';
3. select count(*) as INVALID_OBJECTS from dba_objects where
status='INVALID';

Count the valid objects again after the migration and if count differs then compile all those objects which are becomes invalid which were VALID before migration by checking the list

[brassd]

Running catalog.sql may solve part of the problem, but may invalidate other objects. After the upgrade, just recompile any invalid objects.

Dave

[Halo]

I heard executing utlrp.sql in $O_H/rdbms/admin dir. recompiles invalid objects. Someone plz. confirm this.