I thought that, given disks with 256KB to 4M of ondisk cache and disk arrays with another 1M-16M of cache and storage boxes like EMC,Hitachi, etc with up to 16 GB of CACHE and the UBC and the Oracle BC and Henry Poras' recent post that
"tables and indexes" in the same tspace didn't matter quite as much as it did when I was a youngster? Not that it doesn't matter, just that it's not in the "Top Three Evildoers" List anymore. - ross -----Original Message----- Sent: Tuesday, November 27, 2001 3:40 PM To: Multiple recipients of list ORACLE-L The idea is wonderful and also very old. It was one of the first enhancement requests submitted. As far as I can tell Oracle has never shown an interest in it. Indeed it appears to be going the other way. Take LOB's for instance. You can place the LOB segment in a separate tablespace from the rest of the table's data, but the lob_index is going to go in the same tablespace as the lob_segment. The documentation states: "This clause [lob_index] is deprecated as of Oracle8i. Oracle generates an index for each LOB column. Oracle names and manages the LOB indexes internally. Although it is still possible for you to specify this clause, Oracle Corporation strongly recommends that you no longer do so." Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -----Original Message----- Sent: Tuesday, November 27, 2001 9:32 AM To: Multiple recipients of list ORACLE-L Wonderful idea, Mark. We have scores of users who create their own tables, indexes etc since we are a scientific research institution. It's hard to get users to put in that extra code to place the index in it's own tablespace. Shirley -----Original Message----- From: Mark Leith [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Altering Indexes Just a question off the wall here - kind of related: Does anybody know why Oracle does NOT give the option to have a DEFAULT INDEX TABLESPACE along with TEMPORARY and DEFAULT (for Tables for example).. I know, I know it's just another thing to add to your syntax - but it would be a FAR better way of doing things wouldn't it? I would much prefer to say: create user mark identified by beer default table tablespace USER_DATA quota 100 M on USER_DATA default index tablespace USER_IDXS quota 100 M on USER_IDXS temporary tablespace TEMP; as this totally takes away the nightmare of having them all created in one single tablespace.. Anyone with an "in" with Oracle know the answer? Anyone care to speculate? :> Cheers Mark -----Original Message----- Sent: 27 November 2001 15:20 To: Multiple recipients of list ORACLE-L You can't do it en-mass. Why not write a script to do this. select 'alter index '||index_name||' rebuild <new_tbsp>;' from user_indexes; or somthing similar. Terry -----Original Message----- Sent: Tuesday, November 27, 2001 8:25 AM To: Multiple recipients of list ORACLE-L I have this large DB (approx. 250 tables) that has the tables and indexes in the same tablespace (not my design). Is there a way I can move all of the indexes to a separate tablespace en-mass? I know I can move them one at a time with the alter index command, but that would be rather time consuming. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Ball, Terry 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: Mark Leith 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: Taylor, Shirley 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: MacGregor, Ian A. 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: Mohan, Ross 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).