needsgen.sql
--------------------------------------------------------------------------- -- Filename: needsgen.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 a9 column ID heading "ID" format 9999 column GNAME heading "Group" format a8 SELECT id, gname, sname, oname, type, status FROM dba_repobject WHERE generation_status = 'NEEDSGEN' ORDER BY gname, sname, type, oname /
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.