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

    Unanswered: Snapshot Problem

    Hi All
    Can anybody help me out in solving a problem related to Snapshot. When i am issuing this statement

    CREATE SNAPSHOT Test1
    REFRESH complete
    START WITH SYSDATE
    NEXT LAST_DAY(TRUNC(SYSDATE + 1 )) + 23/24
    WITH ROWID
    As Select * from T_Project@Test.

    Test is the DBLINK by which i am connecting to another database.

    But after sometimes the error message comes as

    ORA-01630: max # extents () reached in temp segment in tablespace
    ORA-02063: preceding line from TEST

    Please give me your suggestions.

    Thanks in advance.

    Regards
    Rasmi

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    The docs say:
    ORA-01630 max # extents (string) reached in temp segment in tablespace string

    Cause: A temporary segment tried to extend past MAXEXTENTS.

    Action: If MAXEXTENTS for the tablespace is less than the system maximum, you can raise that. Otherwise, raise PCTINCREASE for the tablespace.
    So I guess that's what you have to do.

Posting Permissions

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