[Home] [Help]
[Dependency Information]
VIEW: SYS.DBA_LOGSTDBY_NOT_UNIQUE
Object Details
Object Name: | DBA_LOGSTDBY_NOT_UNIQUE |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
List of all the tables with out primary or unique key not null constraints
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OWNER |
VARCHAR2 |
(30) |
|
Schema name of the non-unique table |
TABLE_NAME |
VARCHAR2 |
(30) |
|
Table name of the non-unique table |
BAD_COLUMN |
VARCHAR2 |
(1) |
|
Indicates that the table has a column not useful in the where clause |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TABLE_NAME
, BAD_COLUMN
FROM SYS.DBA_LOGSTDBY_NOT_UNIQUE;
Dependencies
[top of page]
SYS.DBA_LOGSTDBY_NOT_UNIQUE references the following:
-
SYS
-
CCOL$
-
CDEF$
-
COL$
-
ICOL$
-
IND$
-
LOGSTDBY$SRECS
-
LOGSTDBY$TABF
-
TAB$
SYS.DBA_LOGSTDBY_NOT_UNIQUE is referenced by following:
-
PUBLIC
-
DBA_LOGSTDBY_NOT_UNIQUE