Hi,
I have the following table. When doing a select * from horus_owner.horus_objects nothing is shown. This could be reproduced with both 10g and 11g on the database-side.
Regards,
Johannes
-- Wiedergabe von TABLE DDL für Objekt HORUS_OWNER.HORUS_OBJECTS nicht möglich, da DBMS_METADATA internen Generator versucht.
CREATE TABLE HORUS_OWNER.HORUS_OBJECTS
(
ID NUMBER(32, 0) NOT NULL
, TRE_ID NUMBER(32, 0) NOT NULL
, WRK_ID NUMBER(32, 0) NOT NULL
, NAME VARCHAR2(200 BYTE) NOT NULL
, MOD_TYPE VARCHAR2(10 BYTE) NOT NULL
, LOCKED_BY VARCHAR2(30 BYTE)
, PETRI_XML SYS.XMLTYPE
, AOM_XML SYS.XMLTYPE
, SHM_XML SYS.XMLTYPE
, ORG_XML SYS.XMLTYPE
, ROLE_XML SYS.XMLTYPE
, MIT_XML SYS.XMLTYPE
, RUL_XML SYS.XMLTYPE
, TXT_DATA CLOB
, CREATED DATE NOT NULL
, CREATED_BY VARCHAR2(30 BYTE) NOT NULL
, UPDATED_BY VARCHAR2(30 BYTE)
, UPDATED DATE
, SIM_XML SYS.XMLTYPE
, GLOSSARY_XML SYS.XMLTYPE
, CONSTRAINT OBJ_PK PRIMARY KEY
(
ID
)
ENABLE
)
LOGGING
TABLESPACE HORUS_OWNER_DATA
PCTFREE 10
INITRANS 1
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
) NOCOMPRESS
XMLTYPE PETRI_XML STORE AS CLOB
XMLTYPE AOM_XML STORE AS CLOB
XMLTYPE SHM_XML STORE AS CLOB
XMLTYPE ORG_XML STORE AS CLOB
XMLTYPE ROLE_XML STORE AS CLOB
XMLTYPE MIT_XML STORE AS CLOB
XMLTYPE RUL_XML STORE AS CLOB
LOB (TXT_DATA) STORE AS SYS_LOB0000024538C00021$$
(
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
LOGGING
)
XMLTYPE SIM_XML STORE AS CLOB
XMLTYPE GLOSSARY_XML STORE AS CLOBALTER TABLE HORUS_OWNER.HORUS_OBJECTS
ADD CONSTRAINT OBJ_UK UNIQUE
(
WRK_ID
, NAME
, TRE_ID
)
ENABLEALTER TABLE HORUS_OWNER.HORUS_OBJECTS
ADD CONSTRAINT OBJ_TRE_FK FOREIGN KEY
(
TRE_ID
)
REFERENCES HORUS_OWNER.HORUS_TREE_NODES
(
ID
)
ENABLEALTER TABLE HORUS_OWNER.HORUS_OBJECTS
ADD CONSTRAINT AVCON_1243352806_MOD_T_000 CHECK
(MOD_TYPE
IN ('EMP', 'ROL', 'ENT', 'OCH', 'XML', 'SHM', 'OSM', 'BUM', 'BOM',
'BEH', 'KPI', 'RIS', 'SER', 'STR', 'SWO', 'AOM', 'CON', 'GOA', 'BUR'
, 'BPA', 'RES', 'SIM', 'GLO','TEM', 'SAR'))
ENABLECREATE UNIQUE INDEX HORUS_OWNER.OBJ_PK ON HORUS_OWNER.HORUS_OBJECTS (ID ASC)
LOGGING
TABLESPACE HORUS_OWNER_IDX
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX HORUS_OWNER.OBJ_TRE_FK_I ON HORUS_OWNER.HORUS_OBJECTS (TRE_ID ASC)
LOGGING
TABLESPACE HORUS_OWNER_IDX
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE UNIQUE INDEX HORUS_OWNER.OBJ_UK ON HORUS_OWNER.HORUS_OBJECTS (WRK_ID ASC, NAME ASC, TRE_ID ASC)
LOGGING
TABLESPACE HORUS_OWNER_IDX
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX HORUS_OWNER.OBJ_WRK_FK_I ON HORUS_OWNER.HORUS_OBJECTS (WRK_ID ASC)
LOGGING
TABLESPACE HORUS_OWNER_IDX
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL