| 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
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.
-----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
ian_at_slac.stanford.edu
-----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:mark_at_cool-tools.co.uk]
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: 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Taylor, Shirley INET: TaylorSI_at_mar.dfo-mpo.gc.ca 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: MacGregor, Ian A. INET: ian_at_SLAC.Stanford.EDU 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: Mohan, Ross INET: MohanR_at_STARS-SMI.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 Tue Nov 27 2001 - 15:53:53 CST
 |
 |