System Tables

The following system tables are known in MaxDB, but they are empty because the corresponding objects or information does not exist in MaxDB:

ALL_ERRORS
ALL_SOURCE
ALL_SNAPSHOTS
ALL_TRIGGER_COLS

DBA_2PC_NEIGHBORS
DBA_2PC_PENDING
DBA_AUDIT_EXISTS
DBA_AUDIT_OBJECT
DBA_AUDIT_SESSION
DBA_AUDIT_STATEMENT
DBA_AUDIT_TRAIL
DBA_BLOCKERS
DBA_CLUSTERS
DBA_CLU_COLUMNS
DBA_DATA_FILES
DBA_DDL_LOCKS
DBA_DML_LOCKS
DBA_ERRORS
DBA_EXP_FILES
DBA_EXP_OBJECTS
DBA_EXTENTS
DBA_LOCKS
DBA_OBJECT_SIZE
DBA_PRIV_AUDIT_OPTS
DBA_PROFILES
DBA_ROLLBACK_SEGS
DBA_SNAPSHOTS
DBA_SNAPSHOT_LOGS
DBA_SOURCE
DBA_STMT_AUDIT_OPTS
DBA_SYS_PRIVS
DBA_TABLESPACES
DBA_TRIGGER_COLS
DBA_TS_QUOTAS

RESOURCE_COST
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS

USER_AUDIT_OBJECT
USER_AUDIT_SESSION
USER_AUDIT_TRAIL
USER_CLUSTERS
USER_CLU_COLUMNS
USER_ERRORS
USER_EXTENTS
USER_OBJECT_SIZE
USER_SNAPSHOTS
USER_SNAPSHOT_LOGS
USER_SOURCE
USER_SYS_PRIVS
USER_TABLESPACES
USER_TRIGGER_COLS
USER_TS_QUOTAS

The following system table columns always contain a NULL value because the information is not available in the format required in MaxDB:

System Table(s)

Column(s)

ALL_CONSTRAINT, USER_CONSTRAINTS, DBA_CONSTRAINTS

R_CONSTRAINT_NAME

ALL_DEPENDENCIES, USER_DEPENDENCIES, DBA_DEPENDENCIES

REFERENCED_LINK_NAME

ALL_INDEXES, USER_INDEXES, DBA_INDEXES

PREFIX_LENGTH
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENT
MAX_EXTENTS
PCT_INCREASE
PCT_FREE
BLEVEL
LEAF_BLOCKS
AVG_LEAF_BLOCKS_PER_KEY
AVG_DATA_BLOCKS_PER_KEY
CLUSTERING_FACTOR
NUM_ROWS
SAMPLE_SIZE
LAST_ANALYZED
DEGREE
INSTANCES
BUFFER_POOL
DUARTION
PCT_DIRECT_ACCESS
ITYP_OWNER
ITYP_NAME
PARAMETERS
GLOBAL_STATS

ALL_OBJECTS, USER_OBJECTS, DBA_OBJECTS

SUBOBJECT_NAME
DATA_OBJECT_ID

ALL_SYNONYMS, USER_SYNONYMS, DBA_SYNONYMS

DB_LINK

ALL_TABLES, USER_TABLES, DBA_TABLES

CLUSTER_NAME
IOT_NAME
PCT_FREE
PCT_USED
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENT
MAX_EXTENTS
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
BLOCKS
EMPTY_BLOCKS
AVG_SPACE
CHAIN_CNT
AVG_ROW_LEN
AVG_SPACE_FREELIST_BLOCKS
NUM_FREELIST_BLOCKS
DEGREE
INSTANCES
IOT_TYPE
BUFFER_POOL
ROW_MOVEMENT
GLOBAL_STATS
DUARTION
SKIP_CORRUPT
MONITORING

ALL_TAB_COLUMNS, USER_TAB_COLUMNS, DBA_TAB_COLUMNS

DATA_TYPE_MOD
DATA_TYPE_OWNER
LOW_VALUE
HIGH_VALUE
DENSITY
NUM_NULLS
NUM_BUCKETS
LAST_ANALYZED
SAMPLE_SIZE
GLOBAL_STATS
AVG_COL_LENGTH

ALL_TRIGGERS, USER_TRIGGERS, DBA_TRIGGERS

COLUMN_NAME
REFERENCING_NAME
WHEN_CLAUSE
ACTION_TYPE

ALL_VIEWS, USER_VIEWS, DBA_VIEWS

TYPE_TEXT_LENGTH
TYPE_TEXT
OID_TEXT_LENGTH
OID_TEXT
VIEW_TYPE_OWNER
VIEW_TYPE

DBA_IND_COLUMNS

COLUMN_EXPRESSION

USER_FREE_SPACE, DBA_FREE_SPACE

RELATIVE_FNO

USER_RESOURCE_LIMITS

RESOURCE_NAME
LIMIT

USER_SEGMENTS, DBA_SEGMENTS

BYTES
BLOCKS
EXTENTS
INITIAL_EXTENT
NEXT_EXTENT
IN_EXTENT
MAX_EXTENTS
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
BUFFER_POOL
RESOURCE_NAME

USER_SYS_PRIVS

PRIVILEGE

USER_USERS, DBA_USERS

ACCOUNT_STATUS
LOCK_DATE
EXPIRY_DATE
PROFILE
INITIAL_RSRC_CONSUMER_GROUP
EXTERNAL_NAME