gengensup.sql

---------------------------------------------------------------------------
-- Filename:    gengensup.sql
-- Purpose:     Generates calls to generate_replication_support.
-- Author:      Chas. Dye (cdye@excitecorp.com)
-- Date:        27-May-1998
---------------------------------------------------------------------------
undef schema_name

SELECT
        'EXECUTE dbms_repcat.generate_replication_support( -'||chr(10)||
        'sname=>'||chr(39)||upper('&&schema_name')||chr(39)||', -'||chr(10)||
        'oname=>'||chr(39)||oname||chr(39)||', -'||chr(10)||
        'type=>'||chr(39)||type||chr(39)||', -'||chr(10)||
        'distributed=>TRUE);'
FROM    dba_repobject
WHERE   oname NOT LIKE '%$R%'
AND     sname = upper('&&schema_name')
ORDER BY sname, type, oname
/

undef schema_name

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.