constraint_type=?

From: ajt <andretardif_at_gmail.com>
Date: 4 Jan 2007 11:41:04 -0800
Message-ID: <1167939664.182804.6850@11g2000cwr.googlegroups.com>

Has anyone seen this before, constraint_type "?" and what does it mean? It appears to be defined on two sys owned tables

13:00:40 >select unique(constraint_type) from dba_constraints 13:03:42 2 /

C
-

V
R
U
P
?
C
O

SQL> select owner,

            constraint_name,
            table_name,
            constraint_type,
            search_condition, status
       from dba_constraints
      where constraint_type = '?'

OWNER  CONSTRAINT_NAME   TABLE_NAME             C SEARCH_CONDITION

    STATUS
------ ----------------- ---------------------- -

• -------- SYS SYS_C001228 WRI$_ADV_DEFINITIONS ? "TYPE" IS NOT NULL ENABLED

It appears that there is a user defined type in the table SYS.WRI$_ADV_ABSTRACT_T. The type exists and is valid.

14:23:44 >desc sys.WRI$_ADV_DEFINITIONS
 Name
  Null? Type

---

• ------------------------------------------------- ID NOT NULL NUMBER NAME NOT NULL VARCHAR2(30) PROPERTY NOT NULL NUMBER TYPE NOT NULL SYS.WRI$_ADV_ABSTRACT_T

14:24:43 >select * from dba_objects where object_name = 'WRI$_ADV_ABSTRACT_T';

OWNER        OBJECT_NAME                     SUBOBJECT_NAME
     OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE         CREATED


------------ -------------------------------

------------------------------ ---------- --------------

------------------- ---------

LAST_DDL_ TIMESTAMP            STATUS  T G S


--------- -------------------- ------- - - -

SYS          WRI$_ADV_ABSTRACT_T
          3687                TYPE                14-NOV-06

14-NOV-06 2006-11-14:15:26:40 VALID N N N

SYS          WRI$_ADV_ABSTRACT_T
          8919                TYPE BODY           14-NOV-06

Received on Thu Jan 04 2007 - 13:41:04 CST