Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    4

    Unanswered: snapshot not registered

    Hi!

    Can any one explain me what is going wrong in, when i am creating
    snapshots from the master site the object is not been registered in the sys.slog$ view at the master site.

    I have created the database link between the master site and the clinte site
    created snapshot logs at the master site.
    and when i am creating the snapshot at the clinte site, the snapshot is been created but the entry in the sys.slog$ view is not been registered.

    I am creating the snapshot using:
    create snapshot abcd tablespace xxxx USING INDEX TABLESPACE xxxx_INDEX REFRESH with rowid for update as select * from abcd@yyyy where zzzz<>2;

    Thanks in Advance

    KK

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Try generating replication support on the MASTER side and see what happens ...

    dbms_repcat.generate_replication_support

    Also, after you created the snapshot on the client side, did you run

    dbms_repcat.create_snapshot_repobject

    HTH
    Gregg

Posting Permissions

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