Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
dbms_aq_inv.internal_purge_queue_table(
qt_schema IN VARCHAR2,
qt_name IN VARCHAR2,
qt_flags IN BINARY_INTEGER,
tobjno IN NUMBER,
qt_sort_cols IN BINARY_INTEGER,
delivery_mode IN BINARY_INTEGER,
purge_condition IN VARCHAR2,
invoker IN VARCHAR2,
ifjms IN BOOLEAN);
dbms_aq_inv.purge_buffered_mcq_table(
qt_schema IN VARCHAR2,
qt_name IN VARCHAR2,
qt_objno IN NUMBER,
qt_flags IN NUMBER,
purge_condition IN VARCHAR2,
invoker IN VARCHAR2);
dbms_aq_inv.purge_buffered_scq_table(
qt_schema IN VARCHAR2,
qt_name IN VARCHAR2,
qt_objno IN VARCHAR2,
purge_condition IN VARCHAR2,
invoker IN VARCHAR2);
dbms_aq_inv.purge_eligible_rcpt_messages(
qt_schema IN VARCHAR2,
qt_name IN VARCHAR2,
name_arr IN sys.dbms_aq_inv.name_list,
que_num_arr IN sys.dbms_aq_inv.queue#_list,
enq_time_arr IN sys.dbms_aq_inv.enq_time_list,
step_no_arr IN sys.dbms_aq_inv.step_no_list,
msg_prty_arr IN sys.dbms_aq_inv.msg_prty_list,
chain_no_arr IN sys.dbms_aq_inv.chain_no_list,
local_order_no_arr IN sys.dbms_aq_inv.local_order_no_list,
msg_id_arr IN sys.dbms_aq_inv.msg_id_list,
msg_state_arr IN sys.dbms_aq_inv.msg_state_list,
qt_sort_cols IN NUMBER,
ifallexpmsgs IN BOOLEAN);
dbms_aq_inv.purge_eligible_rcpt_msgs_txn(
qt_schema IN VARCHAR2,
qt_name IN VARCHAR2,
name_arr IN sys.dbms_aq_inv.name_list,
que_num_arr IN sys.dbms_aq_inv.queue#_list,
enq_time_arr IN sys.dbms_aq_inv.enq_time_list,
step_no_arr IN sys.dbms_aq_inv.step_no_list,
msg_prty_arr IN sys.dbms_aq_inv.msg_prty_list,
chain_no_arr IN sys.dbms_aq_inv.chain_no_list,
local_order_no_arr IN sys.dbms_aq_inv.local_order_no_list,
msg_id_arr IN sys.dbms_aq_inv.msg_id_list,
msg_state_arr IN sys.dbms_aq_inv.msg_state_list,
qt_sort_cols IN NUMBER,
ifallexpmsgs IN BOOLEAN);
dbms_aq_inv.purge_eligible_sub_messages(
qt_schema IN VARCHAR2,
qt_name IN VARCHAR2,
sub_id_arr IN sys.dbms_aq_inv.sub_id_list,
enq_time_arr IN sys.dbms_aq_inv.enq_time_list,
step_no_arr IN sys.dbms_aq_inv.step_no_list,
msg_prty_arr IN sys.dbms_aq_inv.msg_prty_list,
chain_no_arr IN sys.dbms_aq_inv.chain_no_list,
local_order_no_arr IN sys.dbms_aq_inv.local_order_no_list,
msg_id_arr IN sys.dbms_aq_inv.msg_id_list,
msg_state_arr IN sys.dbms_aq_inv.msg_state_list,
qt_sort_cols IN NUMBER,
ifallexpmsgs IN BOOLEAN);
dbms_aq_inv.purge_eligible_sub_msgs_txn(
qt_schema IN VARCHAR2,
qt_name IN VARCHAR2,
sub_id_arr IN sys.dbms_aq_inv.sub_id_list,
enq_time_arr IN sys.dbms_aq_inv.enq_time_list,
step_no_arr IN sys.dbms_aq_inv.step_no_list,
msg_prty_arr IN sys.dbms_aq_inv.msg_prty_list,
chain_no_arr IN sys.dbms_aq_inv.chain_no_list,
local_order_no_arr IN sys.dbms_aq_inv.local_order_no_list,
msg_id_arr IN sys.dbms_aq_inv.msg_id_list,
msg_state_arr IN sys.dbms_aq_inv.msg_state_list,
qt_sort_cols IN NUMBER,
ifallexpmsgs IN BOOLEAN);
dbms_aq_inv.purge_persistent_mcq_table(
qt_schema IN VARCHAR2,
qt_name IN VARCHAR2,
purge_condition IN VARCHAR2,
qt_flags IN NUMBER,
qt_sort_cols IN NUMBER,
ifjms IN BOOLEAN,
invoker IN VARCHAR2);
dbms_aq_inv.purge_persistent_scq_table(
qt_schema IN VARCHAR2,
qt_name IN VARCHAR2,
qt_flags IN BINARY_INTEGER,
purge_condition IN VARCHAR2,
invoker IN VARCHAR2);