Message-Id: <10541.110619@fatcity.com> From: Rajesh Dayal Date: Wed, 28 Jun 2000 09:38:18 +0400 Subject: RE: # of Indexes Hi Ruth, Even I was thinking in same direction... You made me tense when you wrote that I have to be on Oracle 8 or 8i. I checked back manuals (on technet), this option is available on 7.3 as well ( I have to perform this activity on both 7.3 and 8.0.5). Thanks for replying anyway .... Cheers, Rajesh -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Ruth Gramolini Sent: Tuesday, June 27, 2000 8:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: # of Indexes The easy way to do this is to spool the output of this statement; select 'alter index '||owner||'.'||index_name||' rebuild tablespace YOUR_TS_NAME;' from all_indexes; Then run the spooled file and this will rebuild all of your indexes in the the required tablespace. I believe you have to be in Oracle8 or 8i. Regards, Ruth G. ----- Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Tuesday, June 27, 2000 3:04 AM > Hi All, > I have to move all indexes of a schema from one Tablespace to another > Tablespace (currently Tables as well as Indexes are in the same TS ;-((. > > > But when I query DBA_OBJECTS/DBA_INDEXES for that schema the no of > indexes come to be 179. When I export the objects of that schema and > create the indexfile (by importing ) then no of Indexes is coming to be > 89 only. Could someone point out that why is this difference? Is this > because of System created indexes for unique/primery keys ? If yes then > is there any way out to move those indexes to diff Tablespace ? > > Thanks for help.... > Rajesh > -- > Author: Rajesh Dayal > INET: Rajesh@ohitelecom.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@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). > -- Author: Ruth Gramolini INET: rgramolini@tax.state.vt.us 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@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