| 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: 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;
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: ken.janusz_at_sufsys.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: TBall_at_birch.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: mark_at_cool-tools.co.uk 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 Tue Nov 27 2001 - 11:21:21 CST
 |
 |