error when creating snapshot

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"

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 Wed Jul 18 2001 - 17:08:40 CEST