Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Exclamation Unanswered: How to setup Snapshot site without connecting to master site

    Is it possible to configure Snapshot Site without connecting to Master Site In Offline Instantiation or In Offline Deployment.

    If so please can any one kindly send script or suggest me better solution

    Thank's

  2. #2
    Join Date
    Feb 2004
    Posts
    9

    help me out pls

    help me out pls

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Yes you can build snapshots without being connect to the MASTER db. In the create snapshot statement, use BUILD DEFERRED

    ex:
    CREATE SNAPSHOT "CUSTOMER"
    STORAGE ( INITIAL 16384 NEXT 16384 MAXEXTENTS 249)
    PARALLEL ( DEGREE 1)
    LOGGING
    TABLESPACE "CUSTOMER"
    BUILD DEFERRED
    USING INDEX TABLESPACE "USER_INDEX"
    STORAGE( INITIAL 16384 NEXT 16384 MAXEXTENTS 249 )
    REFRESH FAST
    ON DEMAND
    FOR UPDATE
    AS
    SELECT * FROM CUSTOMER@masterdatabase.world;

    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
  •