| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> How much TEMP space is needed for index creation
OK, i've got a table with 302068428 rows. Im in the process of creating a nonunique index on this table, how much space do i need in the TEMP tablespace for the creation of this index.
Name Null? Type ----------------------------------------- -------- --------------------- SEQUENCEID NOT NULL NUMBER(20) TRANSACTIONCODE VARCHAR2(1) DISTRICT VARCHAR2(3) CUSTOMERACCOUNT VARCHAR2(8) CUSTOMERSUBACCOUNT VARCHAR2(3) SUBSCRIBERSEQNUM VARCHAR2(7) EFFECTIVEDATE VARCHAR2(8) PRICEABLEITEMID VARCHAR2(5) BASICPRICEABLEITEMID VARCHAR2(5) SERVICESTATUSCODE VARCHAR2(2) SERVICINGSALESFORCEID VARCHAR2(8) SERVICINGSALESFORCELVL VARCHAR2(1) SUPPLSERVSTARTDATE VARCHAR2(8) ORIGSUPPLSERVSTARTDT VARCHAR2(8) PRICEABLEITEMTYPE VARCHAR2(2) INPLANIND VARCHAR2(1) BILLFREQUENCY VARCHAR2(1) MAILBOXNAME VARCHAR2(30) MAILBOXLANGUAGE VARCHAR2(2) PAGERTYPE VARCHAR2(1) APPACCESSMAILBOXNO VARCHAR2(10) TELEANSWLANUAGE1 VARCHAR2(2) TELEANSWLANUAGE2 VARCHAR2(2) TELEANSWLANUAGE3 VARCHAR2(2) SERVICESEQNUM VARCHAR2(7) SWITCHRELATEDIND VARCHAR2(1) EXPIRATIONDATE VARCHAR2(8) UPLOADDATE DATE D2SUBID NUMBER SWPRODRELID NUMBER D_EFFECTIVEDATE DATE D_EXPIRATIONDATE DATE
The non-unique index will be on these columns, SEQUENCEID, D_EFFECTIVEDATE, D_EXPIRATIONDATE, SERVICESTATUSCODE, TRANSACTIONCODE The sort area size is set to 10000000.
How do i work out how much space is needed.
TIA Zabair
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: zabair ahmed
INET: zabaira_at_hotmail.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). Received on Mon May 21 2001 - 03:13:21 CDT
 |
 |