| Column Name
| Description
|
| COMMENT_TEXT (USER_AUDIT_OBJECT)
|
|
| COMMENT_TEXT (USER_AUDIT_STATEMENT)
|
|
| COMMENT_TEXT (DBA_AUDIT_STATEMENT)
|
|
| COMMENT_TEXT (DBA_AUDIT_OBJECT)
|
|
| COMMENT_TEXT (DBA_AUDIT_TRAIL)
| Text comment on the audit trail entry. Also indicates how the user was authenticated. The method can be one of the following: 1. "DATABASE" - authentication was done by password. 2. "NETWORK" - authentication was done by Net8 or the Advanced Networking Option. 3. "PROXY" - the client was authenticated by another user. The name of the proxy user follows the method type.
|
| COMMENT_TEXT (USER_AUDIT_TRAIL)
| Text comment on the audit trail entry. Also indicates how the user was authenticated. The method can be one of the following: 1. "DATABASE" - authentication was done by password. 2. "NETWORK" - authentication was done by Net8 or the Advanced Networking Option. 3. "PROXY" - the client was authenticated by another user. The name of the proxy user follows the method type.
|
| DDL_TEXT (ALL_REPCAT_TEMPLATE_OBJECTS)
| DDL string for creating the object or WHERE clause for snapshot query.
|
| DDL_TEXT (DBA_IAS_GEN_STMTS_EXP)
|
|
| DDL_TEXT (DBA_IAS_PREGEN_STMTS)
|
|
| DDL_TEXT (USER_REPCAT_TEMPLATE_OBJECTS)
| DDL string for creating the object or WHERE clause for snapshot query.
|
| DDL_TEXT (DBA_REPCAT_TEMPLATE_OBJECTS)
| DDL string for creating the object or WHERE clause for snapshot query.
|
| DDL_TEXT (DBA_IAS_POSTGEN_STMTS)
|
|
| DDL_TEXT (DBA_IAS_GEN_STMTS)
|
|
| OID_TEXT (DBA_VIEWS)
| WITH OBJECT OID clause of the object view
|
| OID_TEXT (USER_VIEWS)
| WITH OBJECT OID clause of the object view
|
| OID_TEXT (ALL_VIEWS)
| WITH OBJECT OID clause of the object view
|
| OID_TEXT_LENGTH (DBA_VIEWS)
| Length of the WITH OBJECT OID clause of the object view
|
| OID_TEXT_LENGTH (ALL_VIEWS)
| Length of the WITH OBJECT OID clause of the object view
|
| OID_TEXT_LENGTH (USER_VIEWS)
| Length of the WITH OBJECT OID clause of the object view
|
| POLICY_TEXT (USER_AUDIT_POLICIES)
| Audit condition
|
| POLICY_TEXT (ALL_AUDIT_POLICIES)
| Audit condition
|
| POLICY_TEXT (DBA_AUDIT_POLICIES)
| Audit condition
|
| SQL_TEXT (USER_OUTLINES)
| SQL text of the query
|
| SQL_TEXT (V$SQLXS)
|
|
| SQL_TEXT (GV$OPEN_CURSOR)
|
|
| SQL_TEXT (GV$SQL_SHARED_MEMORY)
|
|
| SQL_TEXT (GV$SQLTEXT)
|
|
| SQL_TEXT (V$SQLTEXT)
|
|
| SQL_TEXT (V$SQL)
|
|
| SQL_TEXT (ALL_OUTLINES)
| SQL text of the query
|
| SQL_TEXT (USER_RESUMABLE)
| The current SQL text
|
| SQL_TEXT (DBA_OUTLINES)
| SQL text of the query
|
| SQL_TEXT (GV$SQLAREA)
|
|
| SQL_TEXT (GV$SQLTEXT_WITH_NEWLINES)
|
|
| SQL_TEXT (V$SQLAREA)
|
|
| SQL_TEXT (DBA_FGA_AUDIT_TRAIL)
| SQL text of the query
|
| SQL_TEXT (V$SQL_SHARED_MEMORY)
|
|
| SQL_TEXT (V$OPEN_CURSOR)
|
|
| SQL_TEXT (DBA_RESUMABLE)
| The current SQL text
|
| SQL_TEXT (V$SQLTEXT_WITH_NEWLINES)
|
|
| SQL_TEXT (GV$SQL)
|
|
| SQL_TEXT_PIECE (GV$SQL_REDIRECTION)
|
|
| SQL_TEXT_PIECE (V$SQL_REDIRECTION)
|
|
| TEXT (USER_ERRORS)
| Text of the error
|
| TEXT (USER_SOURCE)
| Source text
|
| TEXT (ALL_VIEWS)
| View text
|
| TEXT (DBA_ERRORS)
| Text of the error
|
| TEXT (ALL_TYPE_VERSIONS)
| Text of the type's spec
|
| TEXT (DBA_SOURCE)
| Source text
|
| TEXT (DBA_TYPE_VERSIONS)
| Text of the type's spec
|
| TEXT (ALL_REPDDL)
| Portion of an argument
|
| TEXT (DBA_REPDDL)
| Portion of an argument
|
| TEXT (ALL_SOURCE)
| Source text
|
| TEXT (USER_TYPE_VERSIONS)
| Text of the type's spec
|
| TEXT (ALL_ERRORS)
| Text of the error
|
| TEXT (DBA_VIEWS)
| View text
|
| TEXT (USER_REPDDL)
| Portion of an argument
|
| TEXT (USER_VIEWS)
| View text
|
| TEXT_LENGTH (DBA_VIEWS)
| Length of the view text
|
| TEXT_LENGTH (ALL_VIEWS)
| Length of the view text
|
| TEXT_LENGTH (USER_VIEWS)
| Length of the view text
|
| TYPE_TEXT (USER_VIEWS)
| Type clause of the object view
|
| TYPE_TEXT (ALL_VIEWS)
| Type clause of the object view
|
| TYPE_TEXT (DBA_VIEWS)
| Type clause of the object view
|
| TYPE_TEXT_LENGTH (DBA_VIEWS)
| Length of the type clause of the object view
|
| TYPE_TEXT_LENGTH (ALL_VIEWS)
| Length of the type clause of the object view
|
| TYPE_TEXT_LENGTH (USER_VIEWS)
| Length of the type clause of the object view
|
| VERSION_TEXT (SM$VERSION)
|
|