Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2009
    Posts
    5

    Unanswered: ORACLE 9i Replication

    Hi,

    i have an oracle database for which multimaster replication has been setup earlier.I wanted to know what are the objects ( say user or tables or schema or tablespace) that are involved in multi master replication.

    How to find this out. Could some one guide me on this.


    Thanks in Advance,
    LavanyaHari

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    SQL> desc dba_mviews
     Name					   Null?    Type
     ----------------------------------------- -------- ----------------------------
     OWNER					   NOT NULL VARCHAR2(30)
     MVIEW_NAME				   NOT NULL VARCHAR2(30)
     CONTAINER_NAME 			   NOT NULL VARCHAR2(30)
     QUERY						    LONG
     QUERY_LEN					    NUMBER(38)
     UPDATABLE					    VARCHAR2(1)
     UPDATE_LOG					    VARCHAR2(30)
     MASTER_ROLLBACK_SEG				    VARCHAR2(30)
     MASTER_LINK					    VARCHAR2(128)
     REWRITE_ENABLED				    VARCHAR2(1)
     REWRITE_CAPABILITY				    VARCHAR2(9)
     REFRESH_MODE					    VARCHAR2(6)
     REFRESH_METHOD 				    VARCHAR2(8)
     BUILD_MODE					    VARCHAR2(9)
     FAST_REFRESHABLE				    VARCHAR2(18)
     LAST_REFRESH_TYPE				    VARCHAR2(8)
     LAST_REFRESH_DATE				    DATE
     STALENESS					    VARCHAR2(19)
     AFTER_FAST_REFRESH				    VARCHAR2(19)
     UNKNOWN_PREBUILT				    VARCHAR2(1)
     UNKNOWN_PLSQL_FUNC				    VARCHAR2(1)
     UNKNOWN_EXTERNAL_TABLE 			    VARCHAR2(1)
     UNKNOWN_CONSIDER_FRESH 			    VARCHAR2(1)
     UNKNOWN_IMPORT 				    VARCHAR2(1)
     UNKNOWN_TRUSTED_FD				    VARCHAR2(1)
     COMPILE_STATE					    VARCHAR2(19)
     USE_NO_INDEX					    VARCHAR2(1)
     STALE_SINCE					    DATE
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2009
    Posts
    2
    Dear ,

    Replication is nothing but a IMAGE copy of your database .
    You are implemented multi master replication , you can fild all objects details from dba_objects ,dba_tables ,dba_tablespaces etc


    Satish Nawle

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •