Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL ALL_REPOBJECT Keyword      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: ALL_REPOBJECT

Definition:
In Oracle PL/SQL, the ALL_REPOBJECT dictionary view maintains the information about all the objects in the replicating groups, which can be accessed by the current user. Note that object-replication group share a one-to-one relationship.

The structure of the view is shown below.

SNAME [VARCHAR2(30)] - Schema name containing the object
ONAME [VARCHAR2(30)] - Object name
TYPE [VARCHAR2(16)] - Object type
STATUS [VARCHAR2(10)] - Last request status
GENERATION_STATUS [VARCHAR2(9)] - Package replication required status
ID [NUMBER] - Local object identifier
OBJECT_COMMENT [VARCHAR2(80)] - Object description
GNAME [VARCHAR2(30)] - Replicated object group name
MIN_COMMUNICATION [VARCHAR2(1)] - Determines the communication required for update
REPLICATION_TRIGGER_EXISTS [VARCHAR2(1)] - Determines whether replicating trigger exists
INTERNAL_PACKAGE_EXISTS [VARCHAR2(1)] - Determines whether internal package exists
GROUP_OWNER [VARCHAR2(30)] - Replicating object group owner
NESTED_TABLE [VARCHAR2(1)] - Determines whether replicating object is storage table or not

 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 52 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?