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).
Received on Tue Nov 27 2001 - 11:52:02 CST
