Re: error when creating snapshot

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 Thu Jul 19 2001 - 09:38:27 CEST