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).
