Переход с 9i на 10g (для баз Супермага) : Oracle

ERRORS DURING RECOMPILATION
---------------------------
18

ORDIM INVALID OBJECTS: /8ba638da_MimeMap - 5 - 29
ORDIM INVALID OBJECTS: /1336c34a_URLHelper - 5 - 29
ORDIM INVALID OBJECTS: /88fd6f5d_Rectangle - 5 - 29
ORDIM INVALID OBJECTS: /239dbc4c_FourCC - 5 - 29
ORDIM INVALID OBJECTS: /9471e89e_OrdMemSeekableSource - 5 - 29
ORDIM INVALID OBJECTS: /4102c2ff_AnnCltInServerHelper - 5 - 29

OWNER OBJECT_TYPE
------------------------------ -------------------
OBJECT_NAME
--------------------------------------------------------------------------------
STATUS
-------
ORDSYS JAVA CLASS
/1336c34a_URLHelper
INVALID

ORDSYS JAVA CLASS
/239dbc4c_FourCC
INVALID

OWNER OBJECT_TYPE
------------------------------ -------------------
OBJECT_NAME
--------------------------------------------------------------------------------
STATUS
-------

ORDSYS JAVA CLASS
/4102c2ff_AnnCltInServerHelper
INVALID

ORDSYS JAVA CLASS
/8ba638da_MimeMap

OWNER OBJECT_TYPE
------------------------------ -------------------
OBJECT_NAME
--------------------------------------------------------------------------------
STATUS
-------
INVALID

ORDSYS JAVA CLASS
/88fd6f5d_Rectangle
INVALID

ORDSYS JAVA CLASS

OWNER OBJECT_TYPE
------------------------------ -------------------
OBJECT_NAME
--------------------------------------------------------------------------------
STATUS
-------
/9471e89e_OrdMemSeekableSource
INVALID

PUBLIC SYNONYM
/1336c34a_URLHelper
INVALID


OWNER OBJECT_TYPE
------------------------------ -------------------
OBJECT_NAME
--------------------------------------------------------------------------------
STATUS
-------
PUBLIC SYNONYM
/239dbc4c_FourCC
INVALID

PUBLIC SYNONYM
/4102c2ff_AnnCltInServerHelper
INVALID

OWNER OBJECT_TYPE
------------------------------ -------------------
OBJECT_NAME
--------------------------------------------------------------------------------
STATUS
-------

PUBLIC SYNONYM
/8ba638da_MimeMap
INVALID

PUBLIC SYNONYM
/88fd6f5d_Rectangle

OWNER OBJECT_TYPE
------------------------------ -------------------
OBJECT_NAME
--------------------------------------------------------------------------------
STATUS
-------
INVALID

PUBLIC SYNONYM
/9471e89e_OrdMemSeekableSource
INVALID


12 строк выбрано.

SCHEMA COMP_NAME VERSION STATUS

SYS Oracle Database Catalog Views 10.2.0.4.0 VALID
SYS Oracle Database Packages and Types 10.2.0.4.0 VALID
WMSYS Oracle Workspace Manager 10.2.0.4.3 VALID
SYS JServer JAVA Virtual Machine 10.2.0.4.0 VALID
SYS Oracle XDK 10.2.0.4.0 VALID
SYS Oracle Database Java Packages 10.2.0.4.0 VALID
ORDSYS Oracle interMedia 10.2.0.4.0 INVALID
MDSYS Spatial 10.2.0.4.0 VALID
CTXSYS Oracle Text 10.2.0.4.0 VALID
XDB Oracle XML Database 10.2.0.4.0 VALID
SYSMAN Oracle Enterprise Manager 10.2.0.4.0 VALID

SQL> select owner,object_type,object_name,status from dba_objects
2 where status='INVALID'
3 ORDER BY 2,3;

OWNER OBJECT_TYPE OBJECT_NAME STATUS
------------------------------ ------------------- ------------------------------------------- ------
ORDSYS JAVA CLASS /1336c34a_URLHelper INVALID
ORDSYS JAVA CLASS /239dbc4c_FourCC INVALID
ORDSYS JAVA CLASS /4102c2ff_AnnCltInServerHelper INVALID
ORDSYS JAVA CLASS /8ba638da_MimeMap INVALID
ORDSYS JAVA CLASS /88fd6f5d_Rectangle INVALID
ORDSYS JAVA CLASS /9471e89e_OrdMemSeekableSource INVALID
PUBLIC SYNONYM /1336c34a_URLHelper INVALID
PUBLIC SYNONYM /239dbc4c_FourCC INVALID
PUBLIC SYNONYM /4102c2ff_AnnCltInServerHelper INVALID
PUBLIC SYNONYM /8ba638da_MimeMap INVALID
PUBLIC SYNONYM /88fd6f5d_Rectangle INVALID
PUBLIC SYNONYM /9471e89e_OrdMemSeekableSource INVALID

12 строк выбрано.