Re: SYS has 3 invalid views

Hi,

        Run the following command

		alter view v_$session_connect_info compile ;
		alter view v_$type_syze compile ;
		alter view v_$sql_shared_memory compile ;

	If the trouble is still there recreate them:

		create view v_$session_connect_info as select * from
sys.v$session_connect_info  ;
		create view v_$type_syze as select * from sys.v$type_syze  ;
		create view v_$sql_shared_memory as select * from sys.v$sql_shared_memory

        Have you got upgarted your database from a 7.3.3.5 or previous release to 7.3.4.0.1.

                If yes the FIXED view definition can have change, so can be the solution.

--
Regards LANGE Francois.
flange_at_pt.lu
29A Route du vin.
L5450 Stadtbredimus.
Grand Duchy Of Luxembourg.
TEL (int) 352 697412.(*)
CEL(int) 352 021193652(*)
Phone numbers are variable length in Luxembourg. Grand Duchy Of Luxembourg is a small country 80 miles on 60 miles between France,Germany and Belgium.         

chrisoc_at_ans.net wrote in article <6hnrkd$gbj$1_at_nnrp1.dejanews.com>...
> My database at 7.3.4.0.1 has 3 invalid views owned by SYS.
> I grepped around and couldn't even find where they were
> supposed to be created.
>
> They are: V_$SESSION_CONNECT_INFO
> V_$TYPE_SIZE
> V_$SQL_SHARED_MEMORY
>
> anyone else had this problem?
>
> Chris O'Connor chrisoc_at_ans.net
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Fri Apr 24 1998 - 01:46:02 CDT