var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Snapshot Problem
Can anybody help me out in solving a problem related to Snapshot. When i am issuing this statement
CREATE SNAPSHOT Test1
START WITH SYSDATE
NEXT LAST_DAY(TRUNC(SYSDATE + 1 )) + 23/24
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.
The docs say:
So I guess that's what you have to do.
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.