| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: index on table with 3 million rows ???
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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: leslie_y_lu_at_yahoo.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Apr 11 2001 - 15:32:34 CDT
(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: udaycb_at_trwasp.com 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: ListGuru_at_fatcity.com (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).
 |
 |