DBA Data[Home] [Help] [Dependency Information]


TABLE: MDSYS.MD$LER

Object Details
Object Name: MD$LER
Object Type: TABLE
Owner: MDSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Unique Key: MD33
  1. ColumnFILENAME
  2. ColumnOWNER
  3. ColumnMDTNAME
Indexes
Index Type Uniqueness Tablespace Column
MD33 NORMAL UNIQUE TablespaceSYSTEM ColumnFILENAME
ColumnOWNER
ColumnMDTNAME
MD$ILER NORMAL NONUNIQUE TablespaceSYSTEM ColumnOWNER
ColumnMDTNAME
Foreign Keys
Table
Foreign Table Foreign Key Column
MD$LER MD32 TableMD$TAB MD$LER OWNER
MD$LER MDTNAME
Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30)
MDTNAME VARCHAR2 (30)
FILENAME VARCHAR2 (255)
NROWS NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      MDTNAME
,      FILENAME
,      NROWS
FROM MDSYS.MD$LER;

Dependencies

[top of page]

MDSYS.MD$LER does not reference any database object

MDSYS.MD$LER is referenced by following:

SchemaMDSYS
ViewALL_MD_LOADER_ERRORS
ViewDBA_MD_LOADER_ERRORS
ViewUSER_MD_LOADER_ERRORS