How to convert the status of object "invalid" to "valid'?

[WilliamLWY]

How to convert the status of object "invalid" to "valid'?

select object_name, status from all_objects where status <> 'VALID';

[marist89]

http://download-west.oracle.com/docs...11.htm#2051917

[WilliamLWY]

if I have a package name VEH_RA_ADDRESSES_SV that the status is INVALID, the owner is APPS and object_type is PACKAGE, I need to recompile it in order to change the status from invalid to valid. The SQL should be

ALTER PACKAGE APPS.VEH_RA_ADDRESSES_SV
COMPILE PACKAGE;

AM I Right?

[zainalj]

in general,
alter compile;
----------------

alter view myview compile;
show err;
alter package mypackage compile;
show err;
alter trigger mytrigger compile;
show err;
alter procedure myproc compile;
show err;
alter function myfunc compile;

[WilliamLWY]

Alter X compile can apply to
Function, package, procedure, trigger, view

How about package body and type?

[marist89]

http://download-west.oracle.com/docs...11.htm#2051917
http://download-west.oracle.com/docs...5a.htm#2057830

[WilliamLWY]

I would like to ask the mypackage name. Is it that same as
select object_name from all_objects where status <> 'INVALID';

Since I try to alter package mypackage compile.
It said object does not exist.

[zainalj]

I wondering s/thing... How old are you williamLWY?

[WilliamLWY]

22

[zainalj]

Originally posted by WilliamLWY
22

No wonder....

How sure are you "alter X compile" work for fucntion/package/etc. Have you tried it? I donno if it is work in 10g... i never touch 10g before