You might not have to increase the tablespace size. Maxextents = 121 is
likely to be a bigger part of the problem. Query dba_tablespaces and
look at your intial and next values as well as your maxextents
parameter. You might find you have enough datafile space and are
choking on the default
There are 2 issues here. First the error. What version of Oracle are you
using? Is the TEMP tablespace set up as TEMPORARY? What block size are
you using (impacts max extents on older versions of Oracle)? If you are
not the only user on the system, you must also account for other sorts
that
-
From: M Rafiq [mailto:[EMAIL PROTECTED]
Sent: Friday, February 21, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: How do you calcuate the temp space needed for view?
Your database having db_block_size 2K so max
Your database having db_block_size 2K so max extents are 121. You may alter
your temp tablespace by
alter tablespace temp default storage(maxextents unlimited); then
alter tablespace temp coalesce;
and try your query. If space is not sufficient in temp ts then message will
come with ORA-1652.
you calcuate the temp space needed for view?
Your database having db_block_size 2K so max extents are 121. You may
alter
your temp tablespace by
alter tablespace temp default storage(maxextents unlimited); then
alter tablespace temp