SESSIONROWSCHANGED: Data Dictionary Rows Changed in Session
read only
- Katalog:
DataDictionary - Schema:
Invantive - Label: Rows Changed in Session
Audit of rows changed in a session.
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle SESSIONROWSCHANGED sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
COLUMN_ |
varchar2 |
Spalte 1 | Name of the first column being updated. | ||
DURATION_ |
double |
Duration | Duration in milliseconds of the change. | ||
ERROR_ |
varchar2 |
Fehlermeldung | Error message that occurred during executing the change. | ||
EXECUTION_ |
datetime |
Datum erstellen | Date at which the change was executed (UTC). | ||
ID |
int32 |
ID | Unique ID of the change. | ||
NEW_ |
varchar2 |
New Value 1 | New value of the first column. | ||
OLD_ |
varchar2 |
Old Value 1 | Old value of the first column. | ||
PARTITION |
varchar2 |
Partition | Specific partition on which the change was executed. | ||
PROVIDER_ |
varchar2 |
Datencontaineralias | Data container alias. | ||
PROVIDER_ |
varchar2 |
Datenkontainer ID | Data container ID. | ||
PROVIDER_ |
varchar2 |
Treiberbeschreibung | Provider description. | ||
PROVIDER_ |
guid |
Treiber Instanz-UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Anbietername | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Treiber Kurzname | Provider short name. | ||
SQL_ |
varchar2 |
SQL Revert | SQL statement to revert all columns changed. | ||
SUCCESSFUL |
char |
Succesful | Indicator whether the change completed successfully. | ||
TABLE_ |
varchar2 |
Tabelle Name | Name of the table or view. | ||
TXN_ID |
int64 |
Transaktions-ID | Transaction ID of the change. | ||
UNIQUE_ |
varchar2 |
Unique Key 1 | Value of the first column of the unique key. | ||
UNIQUE_ |
varchar2 |
Unique Key 2 | Value of the second column of the unique key. | ||
UNIQUE_ |
varchar2 |
Unique Key 3 | Value of the third column of the unique key. | ||
UNIQUE_ |
varchar2 |
Unique Key 4 | Value of the fourth column of the unique key. | ||
UNIQUE_ |
varchar2 |
Unique Key 5 | Value of the fifth column of the unique key. | ||
UNIQUE_ |
varchar2 |
Unique Key 6 | Value of the sixth column of the unique key. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
SESSIONROWSCHANGED_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Textual | The data container of the change, while that data container is active; the history of changes outlives a data container that was closed. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: