Attachment 579981 Details for Bug 814839 – sql script to turn on oracle logging on relevant tables

sql script to turn on oracle logging on relevant tables

ora-logging.sql (text/x-sql), 6.46 KB, created by John Mazzitelli on 2012-04-24 19:56:37 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: John Mazzitelli

Created: 2012-04-24 19:56:37 UTC

Size: 6.46 KB

patch

obsolete

>ALTER TABLE rhq_advisory LOGGING;
>ALTER TABLE rhq_advisory_buglist LOGGING;
>ALTER TABLE rhq_advisory_cve LOGGING;
>ALTER TABLE rhq_advisory_package LOGGING;
>ALTER TABLE rhq_affinity_group LOGGING;
>ALTER TABLE rhq_agent LOGGING;
>ALTER TABLE rhq_alert LOGGING;
>ALTER TABLE rhq_alert_condition LOGGING;
>ALTER TABLE rhq_alert_condition_log LOGGING;
>ALTER TABLE rhq_alert_dampen_event LOGGING;
>ALTER TABLE rhq_alert_definition LOGGING;
>ALTER TABLE rhq_alert_notif_log LOGGING;
>ALTER TABLE rhq_alert_notification LOGGING;
>ALTER TABLE rhq_architecture LOGGING;
>ALTER TABLE rhq_availability LOGGING;
>ALTER TABLE rhq_bundle LOGGING;
>ALTER TABLE rhq_bundle_deployment LOGGING;
>ALTER TABLE rhq_bundle_destination LOGGING;
>ALTER TABLE rhq_bundle_file LOGGING;
>ALTER TABLE rhq_bundle_res_dep_hist LOGGING;
>ALTER TABLE rhq_bundle_res_deploy LOGGING;
>ALTER TABLE rhq_bundle_type LOGGING;
>ALTER TABLE rhq_bundle_version LOGGING;
>ALTER TABLE rhq_bundle_version_repo LOGGING;
>ALTER TABLE rhq_calltime_data_key LOGGING;
>ALTER TABLE rhq_calltime_data_value NOLOGGING;
>ALTER TABLE rhq_conf_prop_def_enum LOGGING;
>ALTER TABLE rhq_config LOGGING;
>ALTER TABLE rhq_config_def LOGGING;
>ALTER TABLE rhq_config_group_update LOGGING;
>ALTER TABLE rhq_config_pd_osrc LOGGING;
>ALTER TABLE rhq_config_prop_constr LOGGING;
>ALTER TABLE rhq_config_prop_def LOGGING;
>ALTER TABLE rhq_config_prop_grp_def LOGGING;
>ALTER TABLE rhq_config_property LOGGING;
>ALTER TABLE rhq_config_template LOGGING;
>ALTER TABLE rhq_config_update LOGGING;
>ALTER TABLE rhq_content_req LOGGING;
>ALTER TABLE rhq_content_source LOGGING;
>ALTER TABLE rhq_content_source_type LOGGING;
>ALTER TABLE rhq_content_src_sync LOGGING;
>ALTER TABLE rhq_create_res_hist LOGGING;
>ALTER TABLE rhq_cve LOGGING;
>ALTER TABLE rhq_dashboard LOGGING;
>ALTER TABLE rhq_dashboard_portlet LOGGING;
>ALTER TABLE rhq_delete_res_hist LOGGING;
>ALTER TABLE rhq_distribution LOGGING;
>ALTER TABLE rhq_distribution_file LOGGING;
>ALTER TABLE rhq_distribution_type LOGGING;
>ALTER TABLE rhq_drift LOGGING;
>ALTER TABLE rhq_drift_change_set LOGGING;
>ALTER TABLE rhq_drift_def_template LOGGING;
>ALTER TABLE rhq_drift_definition LOGGING;
>ALTER TABLE rhq_drift_file LOGGING;
>ALTER TABLE rhq_drift_set LOGGING;
>ALTER TABLE rhq_event LOGGING;
>ALTER TABLE rhq_event_def LOGGING;
>ALTER TABLE rhq_event_source LOGGING;
>ALTER TABLE rhq_failover_details LOGGING;
>ALTER TABLE rhq_failover_list LOGGING;
>ALTER TABLE rhq_group_def LOGGING;
>ALTER TABLE rhq_installed_package LOGGING;
>ALTER TABLE rhq_installed_pkg_hist LOGGING;
>ALTER TABLE rhq_meas_data_num_r00 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r01 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r02 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r03 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r04 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r05 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r06 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r07 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r08 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r09 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r10 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r11 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r12 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r13 NOLOGGING;
>ALTER TABLE rhq_meas_data_num_r14 NOLOGGING;
>ALTER TABLE rhq_measurement_bline LOGGING;
>ALTER TABLE rhq_measurement_data_num_1d LOGGING;
>ALTER TABLE rhq_measurement_data_num_1h LOGGING;
>ALTER TABLE rhq_measurement_data_num_6h LOGGING;
>ALTER TABLE rhq_measurement_data_trait LOGGING;
>ALTER TABLE rhq_measurement_def LOGGING;
>ALTER TABLE rhq_measurement_oob LOGGING;
>ALTER TABLE rhq_measurement_oob_tmp LOGGING;
>ALTER TABLE rhq_measurement_sched LOGGING;
>ALTER TABLE rhq_numbers LOGGING;
>ALTER TABLE rhq_operation_def LOGGING;
>ALTER TABLE rhq_operation_history LOGGING;
>ALTER TABLE rhq_operation_schedule LOGGING;
>ALTER TABLE rhq_package LOGGING;
>ALTER TABLE rhq_package_bits LOGGING;
>ALTER TABLE rhq_package_inst_step LOGGING;
>ALTER TABLE rhq_package_type LOGGING;
>ALTER TABLE rhq_package_version LOGGING;
>ALTER TABLE rhq_partition_details LOGGING;
>ALTER TABLE rhq_partition_event LOGGING;
>ALTER TABLE rhq_permission LOGGING;
>ALTER TABLE rhq_pkg_prd_map LOGGING;
>ALTER TABLE rhq_pkg_ver_content_src_map LOGGING;
>ALTER TABLE rhq_plugin LOGGING;
>ALTER TABLE rhq_prd_ver LOGGING;
>ALTER TABLE rhq_principal LOGGING;
>ALTER TABLE rhq_process_scan LOGGING;
>ALTER TABLE rhq_qrtz_blob_triggers LOGGING;
>ALTER TABLE rhq_qrtz_calendars LOGGING;
>ALTER TABLE rhq_qrtz_cron_triggers LOGGING;
>ALTER TABLE rhq_qrtz_fired_triggers LOGGING;
>ALTER TABLE rhq_qrtz_job_details LOGGING;
>ALTER TABLE rhq_qrtz_job_listeners LOGGING;
>ALTER TABLE rhq_qrtz_locks LOGGING;
>ALTER TABLE rhq_qrtz_paused_trigger_grps LOGGING;
>ALTER TABLE rhq_qrtz_scheduler_state LOGGING;
>ALTER TABLE rhq_qrtz_simple_triggers LOGGING;
>ALTER TABLE rhq_qrtz_trigger_listeners LOGGING;
>ALTER TABLE rhq_qrtz_triggers LOGGING;
>ALTER TABLE rhq_raw_config LOGGING;
>ALTER TABLE rhq_repo LOGGING;
>ALTER TABLE rhq_repo_advisory LOGGING;
>ALTER TABLE rhq_repo_content_src_map LOGGING;
>ALTER TABLE rhq_repo_distribution LOGGING;
>ALTER TABLE rhq_repo_group LOGGING;
>ALTER TABLE rhq_repo_group_type LOGGING;
>ALTER TABLE rhq_repo_pkg_version_map LOGGING;
>ALTER TABLE rhq_repo_relation LOGGING;
>ALTER TABLE rhq_repo_relation_type LOGGING;
>ALTER TABLE rhq_repo_repo_group_map LOGGING;
>ALTER TABLE rhq_repo_repo_relation_map LOGGING;
>ALTER TABLE rhq_repo_resource_map LOGGING;
>ALTER TABLE rhq_repo_sync LOGGING;
>ALTER TABLE rhq_resource LOGGING;
>ALTER TABLE rhq_resource_avail LOGGING;
>ALTER TABLE rhq_resource_error LOGGING;
>ALTER TABLE rhq_resource_group LOGGING;
>ALTER TABLE rhq_resource_group_res_exp_map LOGGING;
>ALTER TABLE rhq_resource_group_res_imp_map LOGGING;
>ALTER TABLE rhq_resource_subcat LOGGING;
>ALTER TABLE rhq_resource_type LOGGING;
>ALTER TABLE rhq_resource_type_parents LOGGING;
>ALTER TABLE rhq_role LOGGING;
>ALTER TABLE rhq_role_ldap_group LOGGING;
>ALTER TABLE rhq_role_resource_group_map LOGGING;
>ALTER TABLE rhq_saved_search LOGGING;
>ALTER TABLE rhq_server LOGGING;
>ALTER TABLE rhq_subject LOGGING;
>ALTER TABLE rhq_subject_role_ldap_map LOGGING;
>ALTER TABLE rhq_subject_role_map LOGGING;
>ALTER TABLE rhq_system_config LOGGING;
>ALTER TABLE rhq_tagging LOGGING;
>ALTER TABLE rhq_tagging_bundle_deploy_map LOGGING;
>ALTER TABLE rhq_tagging_bundle_dest_map LOGGING;
>ALTER TABLE rhq_tagging_bundle_map LOGGING;
>ALTER TABLE rhq_tagging_bundle_version_map LOGGING;
>ALTER TABLE rhq_tagging_res_group_map LOGGING;
>ALTER TABLE rhq_tagging_resource_map LOGGING;
>ALTER TABLE jms_messages LOGGING;
>ALTER TABLE jms_transactions LOGGING;
>ALTER TABLE jms_users LOGGING;
>ALTER TABLE jms_roles LOGGING;
>ALTER TABLE jms_subscriptions LOGGING;

Actions: View

Attachments on bug 814839: 579660 | 579981