missing some sys.tables

Hi all,

I think here are some fixed tables lost.

Following select will return 271 entries (Oracle 8i)

   select name from v$fixed_table where name like 'X$%';

but this will return no entry

   select object_name from all_objects where object_name like 'X$%';

I found this behavior because the script session_cursor_cache.sql (from Steve Adams) need an table sys.x$kglcursor. Is there any way to restore the missing tables?

Frank Received on Thu Feb 24 2005 - 07:50:55 CST