Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_REPCAT, 28 of 69
This procedure adds a replicated object to a materialized view group.
DBMS_REPCAT.CREATE_MVIEW_REPOBJECT ( sname IN VARCHAR2, oname IN VARCHAR2, type IN VARCHAR2, ddl_text IN VARCHAR2 := '', comment IN VARCHAR2 := '', gname IN VARCHAR2 := '', gen_objs_owner IN VARCHAR2 := '', min_communication IN BOOLEAN := true, generate_80_compatible IN BOOLEAN := true, gowner IN VARCHAR2 := 'PUBLIC');
Parameter | Description |
---|---|
sname |
Name of the schema in which the object is located. The schema must be same as the schema that owns the master table or master materialized view on which this materialized view is based. |
oname |
Name of the object that you want to add to the replicated materialized view group. |
type |
Type of the object that you are replicating. The following types are supported:
FUNCTION SNAPSHOT
INDEX SYNONYM
INDEXTYPE TRIGGER
OPERATOR TYPE
PACKAGE TYPE BODY
PACKAGE BODY VIEW
PROCEDURE |
ddl_text |
For objects of type '' (an empty string)
If a materialized view with the same name already exists, then Oracle ignores the DDL and registers the existing materialized view as a replicated object. If the master table or master materialized view for a materialized view does not exist in the replication group of the master designated for this schema, then Oracle raises a If the DDL is supplied without specifying a schema, then the default schema is the replication administrator's schema. Be sure to specify the schema if it is other than the replication administrator's schema.
If the object is not of type |
comment |
This comment is added to the |
gname |
Name of the replicated materialized view group to which you are adding an object. The schema name is used as the default group name if none is specified, and a materialized view group with the same name as the schema must exist for the procedure to complete successfully. |
gen_objs_owner |
Name of the user you want to assign as owner of the transaction. |
min_communication |
Set to |
generate_80_compatible |
Set to |
gowner |
Owner of the materialized view group. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|