Re: error when creating snapshot

Hi,

myProject_data_ts is not temporary tablespace, what's your point?

Cui

"Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> wrote in message news:<9j62ej$nks$1_at_news247.cnt.ru>...
> Hello!
>
>
> Pen, Cui <p_cui_at_hotmail.com> ñîîáùèë â íîâîñòÿõ
> ñëåäóþùåå:50e569bf.0107180708.24ff416f_at_posting.google.com...
> > Hi all,
> >
> > I created a snapshot in my Oracle7.3.4. When I used
> >
> > create snapshot mySnapShot
> > pctfree 5
> > tablespace myProject_data_ts
> > storage (initial 100k next 100k pctincrease 0)
> > refresh complete
> > start with SysDate
> > next SysDate+7
> > as select * from myTable_at_myDev_data.world;
> >
> > I always got the error message: "ORA-01630: max # extents (249)
> > reached in temp segment in tablespace myProject_data_ts"
>
> Check that you not using temporary tablespace for your table
> i.e. myProject_data_ts is not temporary tablespace
>
> Best regards!
> Yaroslav.
>
> >
> > Then I used
> >
> > create snapshot mySnapShot
> > refresh complete
> > start with SysDate
> > next SysDate+7
> > as select * from myTable_at_myDev_data.world;
> >
> > The snapshot was created.
> >
> > Can somebody tell me why, thank you in advance!
> >
> > Cui Pen
Received on Tue Jul 24 2001 - 20:39:08 CEST