ODBC ERROR -Oracle Error ORA-1652

[BRL123]

UNABLE TO EXTEND TEMP SEGMENT BY 256 IN TABLESPACE TEMP."
I am running Crystal 8 with an ODBC to an oracle database.


How do I expand the temp space?

 

[SantaMufasa]

The problem you are having is that, although the freespace in your TEMP tablespace may appear to have plenty of room available, there is no TEMP-tablespace-freespace extent that is 256 blocks or larger in size. Therefore, the quickest/easiest method for addressing this issue is to add more disk space to the TEMP tablespace.

Since you have not disclosed in your original post whether your TEMP tablespace is of a "standard data file" variety or if it is of "tempfile" variety, I'll present here the syntax for adding a "standard data file" to your TEMP tablespace, then, if your TEMP tablespace turns out to be of the "tempfile" variety, and if you don't know how to extrapolate my syntax to accommodate that scenario, then you can re-post here for the appropriate syntax:

ALTER TABLESPACE <name of TEMP tablespace>
    ADD DATAFILE '<fully qualified file name>' SIZE 10M
    AUTOEXTEND ON NEXT 10M MAXSIZE 2000M;

This command adds a 10MB-initial, 2GB-maximum data file to your TEMP tablespace. It will get you past your problem. (BTW, you will need DBA-level privileges to effect this command.)

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]