April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- Filename: repcatlog.sql
-- Purpose: Lists all tasks pending in dba_repcatlog queue.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 28-Jun-1996
---------------------------------------------------------------------------
column SOURCE heading "Source" format a6
column MASTER heading "Master" format a6
column SNAME heading "Group" format a10
column STATUS heading "Status" format a14
column REQUEST heading "Request" format a28
column TIMESTAMP heading "Time" format a8
SELECT substr(source, 1, instr(source, '.', 1) -1 ) source,
substr(master, 1, instr(master, '.', 1) -1 ) master,
sname,
status,
request, to_char(timestamp, 'HH24:MI:SS') timestamp
FROM dba_repcatlog
ORDER BY master
/