April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- 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