SELECT "OBJID","DOBJID","NAME","OWNER","OWNERID","TABLESPACE","TSNO","FILENO","BLOCKNO","AUDIT$","COMMENT$","CLUSTERFLAG","MTIME","MODIFIED","TABNO","PCTFREE$","PCTUSED$","INITRANS","MAXTRANS","DEGREE","INSTANCES","CACHE","TEMPFLAGS","PROPERTY","DEFLOG","TSDEFLOG","ROID","RECPBLK","SECONDARYOBJ","ROWCNT","BLKCNT","AVGRLEN","TFLAGS","TRIGFLAG","OBJSTATUS","XDBOOL"
FROM sys.exu10tabs
WHERE NOT EXISTS (
SELECT *
FROM sys.col$ c$
WHERE (c$.obj# = objid AND
(c$.type# = 100 OR
c$.type# = 101 )))
SELECT "OBJID"
, "DOBJID"
, "NAME"
, "OWNER"
, "OWNERID"
, "TABLESPACE"
, "TSNO"
, "FILENO"
, "BLOCKNO"
, "AUDIT$"
, "COMMENT$"
, "CLUSTERFLAG"
, "MTIME"
, "MODIFIED"
, "TABNO"
, "PCTFREE$"
, "PCTUSED$"
, "INITRANS"
, "MAXTRANS"
, "DEGREE"
, "INSTANCES"
, "CACHE"
, "TEMPFLAGS"
, "PROPERTY"
, "DEFLOG"
, "TSDEFLOG"
, "ROID"
, "RECPBLK"
, "SECONDARYOBJ"
, "ROWCNT"
, "BLKCNT"
, "AVGRLEN"
, "TFLAGS"
, "TRIGFLAG"
, "OBJSTATUS"
, "XDBOOL"
FROM SYS.EXU10TABS
WHERE NOT EXISTS (
SELECT *
FROM SYS.COL$ C$
WHERE (C$.OBJ# = OBJID AND
(C$.TYPE# = 100 OR
C$.TYPE# = 101 )))
|
|
|