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 |
ALL_OBJECTS, USER_OBJECTS, DBA_OBJECTS |
SUBOBJECT_NAME |
ALL_SYNONYMS, USER_SYNONYMS, DBA_SYNONYMS |
DB_LINK |
ALL_TABLES, USER_TABLES, DBA_TABLES |
CLUSTER_NAME |
ALL_TAB_COLUMNS, USER_TAB_COLUMNS, DBA_TAB_COLUMNS |
DATA_TYPE_MOD |
ALL_TRIGGERS, USER_TRIGGERS, DBA_TRIGGERS |
COLUMN_NAME |
ALL_VIEWS, USER_VIEWS, DBA_VIEWS |
TYPE_TEXT_LENGTH |
DBA_IND_COLUMNS |
COLUMN_EXPRESSION |
USER_FREE_SPACE, DBA_FREE_SPACE |
RELATIVE_FNO |
USER_RESOURCE_LIMITS |
RESOURCE_NAME |
USER_SEGMENTS, DBA_SEGMENTS |
BYTES |
USER_SYS_PRIVS |
PRIVILEGE |
USER_USERS, DBA_USERS |
ACCOUNT_STATUS |