| reindex [message #55231] |
Mon, 13 January 2003 01:18  |
shareef
Messages: 72
Registered: November 2002
|
Member |
|
|
dear dba guru
can i know how to reindex a database in oracle 8x, please give me a syntax and example. i want to reindex my database.
any help appriciated.
thanks
|
|
|
|
| Re: reindex [message #55232 is a reply to message #55231] |
Mon, 13 January 2003 02:21  |
Raja
Messages: 57
Registered: March 2000
|
Member |
|
|
Hi, to u mean to rebuild the index here's the syntax
ALTER INDEDX <index name> REBUILD [[ONLINE]];
NOTE:
online rebuilding is available only after 8i.
|
|
|
|
| Re: reindex [message #55316 is a reply to message #55231] |
Fri, 17 January 2003 03:35 |
Manish Deshmukh
Messages: 16
Registered: January 2003
|
Junior Member |
|
|
The syntax is alter index <index_name> rebuild.It is
advisible to create a separate tablespace for indexes,so that administration is easy.You can create
a tablespace INDEX and then give the query
alter index <index_name> rebuild tablespace INDEX.You can use the following script:
select 'alter index '||index_name||'rebuild tablespace INDEX;' from user_indexes;
Regards
Manish Deshmukh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
