Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ODBC
Wasim,
I suspect that the cause of your problem may be that the Oracle userID has a temporary tablespace name defined differently than your 40MB temporary tablespace. This is easy to check and easy to fix. If your Oracle userID is WASIM, issue the following query:
SELECT USERNAME, TEMPORARY_TABLESPACE
FROM DBA_USERS
WHERE USERNAME = 'WASIM';
If the result set indicates an unexpected tablespace name such as SYSTEM,
you have found your problem. When a user is created, the default temporary
tablespace is SYSTEMS. It should never be allowed to default. Other than
causing problems such as the one that you are experiencing, it can fragment
the SYSTEM tablespace and negatively overall database performance. To
correct the problem, issue the following statement:
ALTER USER WASIM TEMPORARY TABLESPACE TEMP01; Substitute the name of your temporary tablespace for TEMP01 above.
Otherwise, you may simply need more space. 40M is very small for many systems. If there is an ORDER BY clause in a query producing a result set approaching or exceeding 40M, that can cause your problem. An index build approaching 40M can also cause this result.
Also remember that if multiple users are accessing the same temporary space (typical) and returning large sorted answer sets, the utilization of your temporary tablespace is additive. Also, poor coordination of the configuration parameter SORT_AREA_SIZE and the temporary tablespace extent size can cause poor utilization of available space within the extents.
If none of these things is causing your problem, let me know what symptoms are exhibited that lead you to your diagnosis of that the temporary segment is filled.
-- Regards, Jeff Gentry Carpe Diem!!! Computer Systems Authority Systems Consultant Mailto:jgentry_at_csac.com Mailto:jlgentry_at_worldnet.att.net Wasim Ahmed <wasim.ahmed_at_cressoft.com.pk> wrote in article <61b8m2$hn7$2_at_sussi.cressoft.com.pk>...Received on Sat Oct 11 1997 - 00:00:00 CDT
> Hi,
> We are using VC5.0 which is connected to Oracle7.3 via ODBC. We
have a
> little data in database and the temporary segment is 40M but when we run
the
> application the temporary segment is immediately filled. Can anyone help
me
> about this?
> regards,
> Wasim.
> Please reply to:
> wasim.ahmed_at_cressoft.com.pk
>