Re: snapshots - oracle error ORA-01652:

Definitely a suggestion, may be an answer. You are prefixing the remote table with an username. As which user are you connecting at the other side. You are not by any chance connected as SYS or SYSTEM (and then I seem to remember snapshots are handled by SYS anyway). In that case you could be looking at the wrong temporary tablespace as the temporary tablespace of those two users is usually SYSTEM.

Regards,

Sybrand Bakker, Oracle DBA

"Patrick J. Hayes" <pjh_at_ngdc.noaa.gov> wrote in message news:395250D3.6E4E3BB9_at_ngdc.noaa.gov...
> 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