The redir_defn table holds information about which queues are being redirected and which queues they are being redirected to.
The redir_defn table has the following structure:
TABLE redir_defn (
redir_id number(5) NOT NULL,
start_time number(4) NOT NULL,
start_date number(7) NOT NULL,
end_time number(4) NOT NULL,
end_date number(7) NOT NULL,
queue_name varchar2(24) NOT NULL,
destination varchar2(49) NOT NULL)
The redir_defn table contains one record for each redirection record defined on the system.