Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    35

    Unanswered: replication problem - urgent

    hello everybody

    this problem is very critical for me.

    Please read carefully.

    i stated my project in oracle 9.2

    but due to some problem in the application i was made to switch to 8i
    i have exported using a 8i client (exp) and imported in the 8.1.5 database.

    the project went on fine for 3 month with out problems.

    Now i have to replicate data to other server.


    scripts
    -------
    create snapshot log on abcd tablespace bb pctfree 5 pctused 90 with primary key;
    create snapshot abc tablespace aa refresh with primary key for update as select * from abc@prk;

    note : where prk is a public database link

    I have created the snapshot log with primary key on existing database
    and when I tried to create snapshot on other (8.1.5) server i am getting
    a error

    ORA-12028 snapshot type is not supported by master site string

    Cause: Pre-Oracle8 master sites are not able to support primary key or subquery snapshots that are able to perform a fast refresh.

    Action: Create a ROWID snapshot or use a master table from an Oracle8 site.


    if i do the same thing in 8.1.7 server i am getting error

    ERROR at line 1:
    ORA-12013: updatable snapshots must be simple enough to do fast refresh



    with rowid and primary key with read only the snapshot are created but with primary they are not why?

    please help


    skg

  2. #2
    Join Date
    Jun 2004
    Posts
    2
    Hi,

    I tried the updatable snapshot in Oracle 8.1.7. for me it is working fine.

    I found there is some problem in your script i pasted below

    create snapshot log on abcd tablespace bb pctfree 5 pctused 90 with primary key;

    create snapshot abc tablespace aa refresh with primary key for update as select * from abc@prk;

    Here in the snapshot creation script instead of selecting abcd@prk table u have selected abc@prk table.

    If this is typographical mistake, there may be any other reason.

    thanks

    Shyam


    hello everybody

    this problem is very critical for me.

    Please read carefully.

    i stated my project in oracle 9.2

    but due to some problem in the application i was made to switch to 8i
    i have exported using a 8i client (exp) and imported in the 8.1.5 database.

    the project went on fine for 3 month with out problems.

    Now i have to replicate data to other server.


    scripts
    -------
    create snapshot log on abcd tablespace bb pctfree 5 pctused 90 with primary key;
    create snapshot abc tablespace aa refresh with primary key for update as select * from abc@prk;

    note : where prk is a public database link

    I have created the snapshot log with primary key on existing database
    and when I tried to create snapshot on other (8.1.5) server i am getting
    a error

    ORA-12028 snapshot type is not supported by master site string

    Cause: Pre-Oracle8 master sites are not able to support primary key or subquery snapshots that are able to perform a fast refresh.

    Action: Create a ROWID snapshot or use a master table from an Oracle8 site.


    if i do the same thing in 8.1.7 server i am getting error

    ERROR at line 1:
    ORA-12013: updatable snapshots must be simple enough to do fast refresh



    with rowid and primary key with read only the snapshot are created but with primary they are not why?

    please help

  3. #3
    Join Date
    Apr 2004
    Posts
    35
    dear shyam

    it is just a typo mistake , but my scripts are correct acbd every where


    i should do it in 8.1.5 only

    skg

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    I know changes where made to replication in 8.1.7 -vs- 8.1.5 ... but
    heres what I use for one of my sites:

    MASTER SITE ...
    execute DBMS_REPCAT.CREATE_MASTER_REPOBJECT(-
    gname => '"ACCOUNTING_MASTER"',-
    type => 'TABLE',-
    oname => '"tablename"',-
    sname => '"tableowner"',-
    copy_rows => TRUE,-
    comment => 'xxx table in Accounting Master',-
    use_existing_object => TRUE);

    execute dbms_repcat.generate_replication_support (-
    sname => 'tableowner',-
    oname => 'tablename',-
    type => 'table',-
    distributed => true,-
    min_communication => true);

    CREATE SNAPSHOT LOG ON "tableowner"."tablename"
    TABLESPACE "ACCOUNTING"
    PARALLEL ( DEGREE 1)
    WITH PRIMARY KEY
    EXCLUDING NEW VALUES;

    SNAPSHOT SITE:
    CREATE SNAPSHOT "tableowner"."tablename"
    STORAGE ( INITIAL 5m NEXT 16384 MAXEXTENTS 249)
    PARALLEL ( DEGREE 1)
    LOGGING
    TABLESPACE "ACCOUNTING"
    BUILD IMMEDIATE
    USING INDEX TABLESPACE "USER_INDEX"
    STORAGE( INITIAL 1m NEXT 16384 MAXEXTENTS 249 )
    REFRESH FAST
    ON DEMAND
    FOR UPDATE
    AS
    SELECT * FROM tableowner.tablename@dblink.WORLD;

    execute dbms_repcat.create_snapshot_repobject(-
    sname => tableowner,-
    oname => 'tablename',-
    type => 'SNAPSHOT',-
    ddl_text => 'select * from tableowner.tablename@dblink.world',-
    comment => 'Created by '||user||' on '||sysdate,-
    gname => 'ACCOUNTING_MASTER',-
    gen_objs_owner => 'owner',-
    MIN_COMMUNICATION => TRUE)
    ---- add to refresh group ---
    BEGIN
    DBMS_REFRESH.ADD(
    name => 'accounting_master_ref',
    list => 'tableowner.tablename',
    lax => TRUE);
    END;
    /

    HTH
    Gregg

  5. #5
    Join Date
    Apr 2004
    Posts
    35

    Exclamation

    i wish i get a solution for ora-12028 error
    and replication for 8.1.5 vs 8.1.5 only.

    what you have is given for API kind.

    we do refresh manually on 3 replication sites generally using one master site

    thanks

    skg

Posting Permissions

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