How to Make Invalid object to Validate?
Dear All,
I am using below below query for finding invalid object:
select OBJECT_NAME,CREATED,LAST_DDL_TIME from user_objects where status = 'INVALID' ;
and for validating that ,using below sql:
Please advice me any other process for validating invalid objects.
Regards,
Ashish
I am using below below query for finding invalid object:
select OBJECT_NAME,CREATED,LAST_DDL_TIME from user_objects where status = 'INVALID' ;
and for validating that ,using below sql:
SQL> @?/rdbms/admin/utlrp.sql
but even that , database giving Invalid Object.Please advice me any other process for validating invalid objects.
Regards,
Ashish
1