April 1999
Intermediate to advanced
552 pages
15h 39m
English
--------------------------------------------------------------------------- -- Filename: repobjects.sql -- Purpose: Lists all replicated objects. -- Author: Chas. Dye (cdye@excitecorp.com) -- Date: 28-Jun-1996 --------------------------------------------------------------------------- column SNAME heading "Schema" format a8 column ONAME heading "Object" format a30 column TYPE heading "Type" format a15 column STATUS heading "Status" format a7 column ID heading "ID" format 9999 column GNAME heading "Group" format a10 SELECT id, gname, sname, oname, type, status FROM dba_repobject ORDER BY gname, sname, type, oname /