>
> Hell Ari,
> MERRY CHRISTMAS AND HAPPY NEW YEAR. THANKS ALOT FOR ALL
> THE HELP I HAVE RECIEVED FROM YOU.
>
> PLEASE, COULD YOU HELP ME WITH A SCRIPT WHICH
> CREATES AND DROP INDEXSES AND THEN USES THE ALTER INDEX
> REBUILD COMMAND TO REBUILD THE INDEX.
>
> PLEASE, IS IT POSSIBLE THAT YOU CAN
> ALTER INDEX ( CHANGE STORAGE PARAMETERS)
> THEN USE REBUILD INDEX. DOES IT WORK?
>
> I NEED YOUR LAST HELP BEFORE THE YEAR ENDS.
>
> YOUR STUDENT
> FRANCIS
> **********************************************************************
> " Graduate Life: It's not just a job. It's an indenture."
> ********************************************************************
> Francis Ansah E-mail:ansah@shire.ntc.nokia.com
> Nokia Telecommunications Tel.: +358-9-51123881
> P.O.Box 320,00045,Nokia Group GSM: 040-5324081
>
You can always alter a table or index and change the storage parameters.
The one exception is the INITIAL extent. To change the INITIAL extent
you will have to drop and recreate the object (except for indexes - see
Ken's message below).
(Ken Paulson writes: Using the REBUILD option with ALTER INDEX you can
change the INITIAL extent size and even change which tablespace the
index lives in.)
Sample syntax for the alter index command follows:
ALTER INDEX index_name STORAGE (next 20M pctincrease 0);
The REBUILD command should be used on indexes for which the table had
many updates/insets/deletes. The syntax is:
ALTER INDEX index_name REBUILD;
Some other statements that can help you:
SELECT * FROM USER_INDEXES WHERE INDEX_NAME = 'index_name';
This will give you the storage parameters for the index.
SELECT * FROM USER_IND_COLUMNS WHERE INDEX_NAME = 'index_name';
The above will give you the columns on which the index is based.
Best of luck!
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 150+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page