RE: Index move
Seema - My interpretation of your question is that you are asking whether having the indexes for a table on a separate physical would increase performance. Since this was a standard recommendation for many years, I feel it merits a more detailed reply. If you have an OLTP benchmarking situation with a single table that is being read randomly using the index, then I would expect that moving the index to a separate physical drive would increase performance significantly. I have not tested this directly that I can recall, but I believe this was based on benchmarks. The reason related to the idea that this arrangement would minimize disk head movement. If the index and table are on the same disk, likely they will reside on different positions on the disk. The concern is that random accesses would be slowed by the time it took to reposition the disk drive head from one location to another. This is a mechanical device, so movement inevitably takes time. So, why isn't this practice emphasized today? Here are the reasons I can think of: 1. Benchmarking is not production. A production OLTP system has many simultaneous users accessing many tables. This tends to obscure the benefits of table/index placement. 2. Full table scans don't use the index (by definition), so don't benefit from this placement strategy. 3. Modern systems usually use RAID drives which are more complex, obscuring the benefits of this strategy. 4. Caching inside Oracle (block buffers) and in the I/O system itself also obscure the benefits of this simplistic strategy. Personally I perform this placement whenever it is convenient but I don't make a fetish of it. One practical reason for doing this is when you rebuild an index, the performance benefits are noticeable. But how often do you rebuild indexes? Hi Is any performance gain/impact if I move unique indexes from one tablespace to another tablespace if both tablespaces are on diffrent physical disk? Thanks -Seema -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).
Re: Index move
Title: RE: Index move There is no logic which says index on different disk can give better performance . Instead spreading tables and indexes across disks based on application can help in performance . bp - Original Message - From: Anjo Kolk To: Multiple recipients of list ORACLE-L Sent: Monday, August 19, 2002 10:43 AM Subject: Re: Index move "having the index on a different disk from the table should give you better performance." Why ? - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Monday, August 19, 2002 7:24 PM Subject: RE: Index move Seema, The big question: where is the table? Forgetting about RAID, having the index on a different disk from the table should give you better performance. As far as moving the index to another tablespace without considering the table, it depends on what else that disk is doing. If it is hardly used, then you might get a performance increase. If the disk is busy, moving an index to it could slow things down even more. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Hi Is any performance gain/impact if I move unique indexes from one tablespace to another tablespace if both tablespaces are on diffrent physical disk? Thanks -Seema
Re: Index move
Title: RE: Index move I always want to learn :-) - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Monday, August 19, 2002 8:28 PM Subject: Re: Index move Go get 'em, big guy! - Original Message - From: Anjo Kolk To: Multiple recipients of list ORACLE-L Sent: Monday, August 19, 2002 11:43 AM Subject: Re: Index move "having the index on a different disk from the table should give you better performance." Why ? - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Monday, August 19, 2002 7:24 PM Subject: RE: Index move Seema, The big question: where is the table? Forgetting about RAID, having the index on a different disk from the table should give you better performance. As far as moving the index to another tablespace without considering the table, it depends on what else that disk is doing. If it is hardly used, then you might get a performance increase. If the disk is busy, moving an index to it could slow things down even more. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Hi Is any performance gain/impact if I move unique indexes from one tablespace to another tablespace if both tablespaces are on diffrent physical disk? Thanks -Seema
Re: Index move
Title: RE: Index move
Go get 'em, big guy!
- Original Message -
From:
Anjo Kolk
To: Multiple recipients of list ORACLE-L
Sent: Monday, August 19, 2002 11:43
AM
Subject: Re: Index move
"having the index on a different
disk from the table should give you better performance."
Why ?
- Original Message -
From:
Whittle Jerome Contr NCI
To: Multiple recipients of list ORACLE-L
Sent: Monday, August 19, 2002 7:24
PM
Subject: RE: Index move
Seema,
The big question:
where is the table? Forgetting about RAID, having the index on a different
disk from the table should give you better performance.
As far as moving
the index to another tablespace without considering the table, it depends on
what else that disk is doing. If it is hardly used, then you might get a
performance increase. If the disk is busy, moving an index to it could
slow things down even more.
Jerry Whittle ACIFICS DBA NCI Information Systems Inc.
[EMAIL PROTECTED] 618-622-4145
-Original
Message- From: Seema Singh
[SMTP:[EMAIL PROTECTED]]
Hi Is any performance gain/impact if I
move unique indexes from one tablespace to another tablespace if both
tablespaces are on diffrent physical disk?
Thanks -Seema
Re: Index move
Unlikely. If you can a balanced load across the disks you have available where "balanced" means evenly spread across: - short peak volume timescales - longer summary timescales then you'll be pretty close to optimal. That does not necessarily mean separating data from indexes hth connor --- Seema Singh <[EMAIL PROTECTED]> wrote: > Hi > Is any performance gain/impact if I move unique > indexes from one tablespace > to another tablespace if both tablespaces are on > diffrent physical disk? > > Thanks > -Seema > > > _ > MSN Photos is the easiest way to share and print > your photos: > http://photos.msn.com/support/worldwide.aspx > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Seema Singh > 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
Re: Index move
Title: RE: Index move "having the index on a different disk from the table should give you better performance." Why ? - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Monday, August 19, 2002 7:24 PM Subject: RE: Index move Seema, The big question: where is the table? Forgetting about RAID, having the index on a different disk from the table should give you better performance. As far as moving the index to another tablespace without considering the table, it depends on what else that disk is doing. If it is hardly used, then you might get a performance increase. If the disk is busy, moving an index to it could slow things down even more. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Hi Is any performance gain/impact if I move unique indexes from one tablespace to another tablespace if both tablespaces are on diffrent physical disk? Thanks -Seema
RE: Index move
Title: RE: Index move Seema, The big question: where is the table? Forgetting about RAID, having the index on a different disk from the table should give you better performance. As far as moving the index to another tablespace without considering the table, it depends on what else that disk is doing. If it is hardly used, then you might get a performance increase. If the disk is busy, moving an index to it could slow things down even more. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Hi Is any performance gain/impact if I move unique indexes from one tablespace to another tablespace if both tablespaces are on diffrent physical disk? Thanks -Seema
Index move
Hi Is any performance gain/impact if I move unique indexes from one tablespace to another tablespace if both tablespaces are on diffrent physical disk? Thanks -Seema _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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).
RE: INDEX move
In a multi-user system, you do not get any performance gain by separating indexes from their associated tables. However I like to place them in different tablespaces for other reasons: tables and their corresponding indexes grow at different rates and I prefer to have objects of different types separated. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 05, 2002 10:55 AM To: Multiple recipients of list ORACLE-L Hi I have few of primary key and unique indexes on main data tablespace.I am thinking that if I moved those indexes into diffrent tablespace then we woudl have some performance gain.If I am not correct let me know please?Is any impact if I move primary key and unique indexes to INDEX tablespace? Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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).
Re: INDEX move
1. Data and Index segments have different storage and sizing requirements. That's the main reason for them to be put up in different tablespaces. 2. If all indexes are in a seperate tablespace of their own, one could avoid backing up this tablespace if time and space are a constraint. 3. The I/O should be evenly distributed across the disks and controllers. It will not help you, if you create a new Index tablespace, and put it on a disk, that is currently experiencing heavy I/O. 4. Having data and Index on seperate disks will benefit you, depending on the data access patterns. Sequential access might benefit from it, but would not make any difference to random access. As always, I could stand corrected. Raj "Seema Singh" tmail.com>cc: Sent by: Subject: INDEX move [EMAIL PROTECTED] om June 05, 2002 01:55 PM Please respond to ORACLE-L Hi I have few of primary key and unique indexes on main data tablespace.I am thinking that if I moved those indexes into diffrent tablespace then we woudl have some performance gain.If I am not correct let me know please?Is any impact if I move primary key and unique indexes to INDEX tablespace? Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: 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).
Re: INDEX move
If your index tablespace is on the same physical device than your table tablespace , you will have no gain. Is your bottleneck an IO one ? --- Seema Singh <[EMAIL PROTECTED]> a écrit : > Hi > I have few of primary key and unique indexes on > main data tablespace.I am > thinking that if I moved those indexes into diffrent > tablespace then we > woudl have some performance gain.If I am not correct > let me know please?Is > any impact if I move primary key and unique indexes > to INDEX tablespace? > Thx > -Seema > > > _ > Send and receive Hotmail on your mobile device: > http://mobile.msn.com > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Seema Singh > 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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).
INDEX move
Hi I have few of primary key and unique indexes on main data tablespace.I am thinking that if I moved those indexes into diffrent tablespace then we woudl have some performance gain.If I am not correct let me know please?Is any impact if I move primary key and unique indexes to INDEX tablespace? Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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).
RE: Index move
Thanks for all of the help guys and gals, that made it much easier. Kevin -Original Message- [EMAIL PROTECTED] Sent: Friday, February 02, 2001 12:51 PM To: Multiple recipients of list ORACLE-L How about: set pages 0 set termout off set feedback off spool temp.sql select 'alter index '||owner||'.'||index_name||' rebuild tablespace ' ||tablespace_name||'_idx;' from dba_indexes spool off Ana E. Choto Systems Programmer American University e-Operations Phone (202) 885-2275 Fax (202) 885-2224 "Kevin Kostyszyn" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Index move Sent by: root@fatcity. com 02/02/01 11:30 AM Please respond to ORACLE-L Has anyone ever written a script or something that moved indexes to a different tablespace? One of our schemas has indexes in the wrong tablespace and instead of going throught hem one by one I was wondering if it was possible to move all of them at once? Any ideas, am I out of my mind? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: 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: Kevin Kostyszyn 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).
Re: Index move
How about: set pages 0 set termout off set feedback off spool temp.sql select 'alter index '||owner||'.'||index_name||' rebuild tablespace ' ||tablespace_name||'_idx;' from dba_indexes spool off Ana E. Choto Systems Programmer American University e-Operations Phone (202) 885-2275 Fax (202) 885-2224 "Kevin Kostyszyn" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Index move Sent by: root@fatcity. com 02/02/01 11:30 AM Please respond to ORACLE-L Has anyone ever written a script or something that moved indexes to a different tablespace? One of our schemas has indexes in the wrong tablespace and instead of going throught hem one by one I was wondering if it was possible to move all of them at once? Any ideas, am I out of my mind? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: 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).
Re: Index move
Try this. After having spool file , just change tablespace name from x to y.
set echo off linesize 199 pagesize head off feedback off verify off
spool alter_index_rebuild_&&1
select 'connect system/password' from dual;
select 'alter tablespace &&1 coalesce;' from dual;
select 'connect &&2/&&2' from dual;
select 'set echo on time on timing on' from dual;
select 'spool run_alter_index_rebuild_&&1' from dual;
select 'alter index ' || ind.owner || '.' || ind.index_name ||
' rebuild unrecoverable tablespace &&1;'
from dba_indexes ind, dba_segments seg
where ind.index_name = seg.segment_name
and ind.owner not in ('SYS', 'SYSTEM')
and ind.tablespace_name = upper ('&&1')
order by ind.owner,seg.bytes asc;
select 'exit' from dual;
undefine 1 2
exit
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 08:30:24 -0800
Has anyone ever written a script or something that moved indexes to a
different tablespace? One of our schemas has indexes in the wrong
tablespace and instead of going throught hem one by one I was wondering if
it was possible to move all of them at once? Any ideas, am I out of my
mind?
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
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).
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammad Rafiq
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).
RE: Index move
What about spooling the following output to a file and running it? SELECT 'ALTER INDEX '||index_name||' REBUILD TABLESPACE ' FROM dba_indexes WHERE tablespace_name='' -- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] > -Original Message- > From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] > Sent: Friday, February 02, 2001 09:30 AM > To: Multiple recipients of list ORACLE-L > Subject: Index move > > Has anyone ever written a script or something that moved indexes to a > different tablespace? One of our schemas has indexes in the wrong > tablespace and instead of going throught hem one by one I was wondering if > it was possible to move all of them at once? Any ideas, am I out of my > mind? > > Sincerely, > Kevin Kostyszyn > DBA > Dulcian, Inc > www.dulcian.com > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kevin Kostyszyn > 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: Guidry, Chris 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).
Index move
Has anyone ever written a script or something that moved indexes to a different tablespace? One of our schemas has indexes in the wrong tablespace and instead of going throught hem one by one I was wondering if it was possible to move all of them at once? Any ideas, am I out of my mind? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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).
