SESSIONROWSCHANGED: Data Dictionary Rows Changed in Session
read only
- Catálogo:
DataDictionary - Esquema:
Invantive - Label: Rows Changed in Session
Audit of rows changed in a session.
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla SESSIONROWSCHANGED. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
COLUMN_ |
varchar2 |
Columna 1 | Name of the first column being updated. | ||
DURATION_ |
double |
Duration | Duration in milliseconds of the change. | ||
ERROR_ |
varchar2 |
Mensaje de Error | Error message that occurred during executing the change. | ||
EXECUTION_ |
datetime |
Fecha de Creación | 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 |
Alias del Contenedor de Datos | Data container alias. | ||
PROVIDER_ |
varchar2 |
ID del Contenedor de Datos | Data container ID. | ||
PROVIDER_ |
varchar2 |
Descripción del proveedor | Provider description. | ||
PROVIDER_ |
guid |
UID de instancia de proveedor | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Nombre del Proveedor | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Nombre abreviado del proveedor | Provider short name. | ||
SQL_ |
varchar2 |
Revertir SQL | SQL statement to revert all columns changed. | ||
SUCCESSFUL |
char |
Succesful | Indicator whether the change completed successfully. | ||
TABLE_ |
varchar2 |
Nombre de la Tabla | Name of the table or view. | ||
TXN_ID |
int64 |
Identificación de la Transacción | 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. |
Teclas
| Key | Column | Se refiere a | 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. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: