Trigger Client Events Jp
イベント | 起動するタイミング | 属性関数 |
---|---|---|
BEFORE ALTER | カタログ・オブジェクトの変更時 | ora_sysevent |
ora_login_user | ||
AFTER ALTER | ora_instance_num | |
ora_database_name | ||
ora_dict_obj_type | ||
ora_dict_obj_name | ||
ora_dict_obj_owner | ||
ora_des_encrypted_password | ||
(for ALTER USER events) | ||
ora_is_alter_column | ||
(for ALTER TABLE events) | ||
ora_is_drop_column | ||
(for ALTER TABLE events) | ||
BEFORE DROP | カタログ・オブジェクトの削除時 | ora_sysevent |
ora_login_user | ||
AFTER DROP | ora_instance_num | |
ora_database_name | ||
ora_dict_obj_type | ||
ora_dict_obj_name | ||
ora_dict_obj_owner | ||
BEFORE ANALYZE | 分析文の発行時 | ora_sysevent |
ora_login_user | ||
AFTER ANALYZE | ora_instance_num | |
ora_database_name | ||
ora_dict_obj_name | ||
ora_dict_obj_type | ||
ora_dict_obj_owner | ||
BEFORE ASSOCIATE STATISTICS | 関連統計文の発行時 | ora_sysevent |
ora_login_user | ||
AFTER ASSOCIATE STATISTICS | ora_instance_num | |
ora_database_name | ||
ora_dict_obj_name | ||
ora_dict_obj_type | ||
ora_dict_obj_owner | ||
ora_dict_obj_name_list | ||
ora_dict_obj_owner_list | ||
BEFORE AUDIT | 監査または非監査文の発行時 | ora_sysevent |
AFTER AUDIT | ora_login_user | |
ora_instance_num | ||
BEFORE NOAUDIT | ora_database_name | |
AFTER NOAUDIT | ||
BEFORE COMMENT | オブジェクトへのコメントの追加時 | ora_sysevent |
ora_login_user | ||
AFTER COMMENT | ora_instance_num | |
ora_database_name | ||
ora_dict_obj_name | ||
ora_dict_obj_type | ||
ora_dict_obj_owner | ||
BEFORE CREATE | カタログ・オブジェクトの作成時 | ora_sysevent |
ora_login_user | ||
AFTER CREATE | ora_instance_num | |
ora_database_name | ||
ora_dict_obj_type | ||
ora_dict_obj_name | ||
ora_dict_obj_owner | ||
ora_is_creating_nested_table | ||
(for CREATE TABLE events) | ||
BEFORE DDL | ほとんどのSQL DDL文の発行時。アドバンスト・キューの作成などのPL/SQLプロシージャ・インタフェースを介して発行されたALTER DATABASE、CREATE CONTROLFILE、CREATE DATABASEおよびDDLに対しては起動されません。 | ora_sysevent |
ora_login_user | ||
AFTER DDL | ora_instance_num | |
ora_database_name | ||
ora_dict_obj_name | ||
ora_dict_obj_type | ||
ora_dict_obj_owner | ||
BEFORE DISASSOCIATE STATISTICS | 非関連統計文の発行時 | ora_sysevent |
ora_login_user | ||
AFTER DISASSOCIATE STATISTICS | ora_instance_num | |
ora_database_name | ||
ora_dict_obj_name | ||
ora_dict_obj_type | ||
ora_dict_obj_owner | ||
ora_dict_obj_name_list | ||
ora_dict_obj_owner_list | ||
BEFORE GRANT | 権限付与文の発行時 | ora_sysevent |
ora_login_user | ||
AFTER GRANT | ora_instance_num | |
ora_database_name | ||
ora_dict_obj_name | ||
ora_dict_obj_type | ||
ora_dict_obj_owner | ||
ora_grantee | ||
ora_with_grant_option | ||
ora_privileges | ||
BEFORE LOGOFF | ユーザー・ログオフの開始時 | ora_sysevent |
ora_login_user | ||
ora_instance_num | ||
ora_database_name | ||
AFTER LOGON | ユーザーが正常にログインした後 | ora_sysevent |
ora_login_user | ||
ora_instance_num | ||
ora_database_name | ||
ora_client_ip_address | ||
BEFORE RENAME | 名前の変更文の発行時 | ora_sysevent |
ora_login_user | ||
AFTER RENAME | ora_instance_num | |
ora_database_name | ||
ora_dict_obj_name | ||
ora_dict_obj_owner | ||
ora_dict_obj_type | ||
BEFORE REVOKE | 取消し文の発行時 | ora_sysevent |
ora_login_user | ||
AFTER REVOKE | ora_instance_num | |
ora_database_name | ||
ora_dict_obj_name | ||
ora_dict_obj_type | ||
ora_dict_obj_owner | ||
ora_revokee | ||
ora_privileges | ||
AFTER SUSPEND | 領域不足状態のためSQL文が一時停止された後。トリガーは、文が再開されるようにこの状態を修正する必要があります。 | ora_sysevent |
ora_login_user | ||
ora_instance_num | ||
ora_database_name | ||
ora_server_error | ||
ora_is_servererror | ||
space_error_info | ||
BEFORE TRUNCATE | オブジェクトの切捨て時 | ora_sysevent |
ora_login_user | ||
AFTER TRUNCATE | ora_instance_num | |
ora_database_name | ||
ora_dict_obj_name | ||
ora_dict_obj_type | ||
ora_dict_obj_owner | ||