snapshots - oracle error ORA-01652:

[Quoted] I'm trying to create a snapshot from a remote oracle machine. When I run the "create snapshot" oracle command I get the following error:

CREATE snapshot HYDNOSD

   refresh complete
   START WITH SYSDATE next SysDate+14
   with ROWID
   AS SELECT * FROM SDE_USER.HYDNOSD_at_(machine name);

ORA-01652: unable to extend temp segment by in tablespace ORA-02063: preceding line from Machine name

I've looked through the Deja.com archive for the ORA-01652 error and numerous DBA say that I need to increase the temp area size on the oracle box that had the original table. I have changed the temp area on the oracle box that contains the original table up to 800 mb and still receive the above
ORA-01652 error. The table I'm importing only contains ~6000 records but with many columns.

I've had to create snapshots of over 300 tables and all small tables have had the snapshots created.
So I now the connections are working and the I have the right permission to create the snapshot.

Is the oracle error message leading me down the wrong path? Any one have suggestions on how to get the snapshots to work?

Could you email me directly if you have an answer to this problem.

Patrick Hayes Received on Thu Jun 22 2000 - 00:00:00 CEST