Humm, Looks like someone did not plan accordingly. Easy to do, I've done that
a couple of dozen times. Here is a quick rule of thumb that I use. It is NOT
absolute but I've not had a problem with running out of space in TEMP. The sql
is:
select round(sum(nvl(vsize(<column_name>),1))/1048576)*2 from dual;
Whatever it returns in mega-bytes is what you need in total for dedicated temp
space.
Dick Goulet
____________________Reply Separator____________________
Author: "udaycb" <[EMAIL PROTECTED]>
Date: 4/11/2001 1:35 PM
You have to add another datafile to index tablespace and also increase the
temp tablespace size.
-----Original Message-----
Sent: Wednesday, April 11, 2001 4:55 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I need to build an index on a table of 80 columns with
3 million rows. The index is on 8 columns.
I got ORA-01630: max # extents (n) reached in temp
segment in tablespace ARBOR_INDEX, so I add more index
files and enlarge extents, now I have 2 index files
of 1G each, and tablespace storage is:
ALTER TABLESPACE ARBOR_INDEX
DEFAULT STORAGE (
INITIAL 514K
NEXT 514K
MAXEXTENTS 4080
);
And I still got ORA0-1630. Should I continue to
increase index file size and extents or there is other
way around? The datafile contains that table's
tablespace is only 1G.
I didn't do exp, build index, imp since I believe for
large amount of data, it's better to load the data
first then build index.
Any idea? Thank you.
Leslie
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leslie Lu
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: udaycb
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
