Index rebuild
06/12/2018 11:47
Hi all, I need to move a bunch of indexes from one tablespace to another duringan upgrade. I'm assuming that I just ALTER INDEX, specifying the targettablespace. Some questions: 1) I know it's possible to run the rebuild while connected as the userwho owns the tables, or as SYSTEM or SYS. Is any one of theseconsidered to be best practice? 2) I notice that Oracle has automatically added indexes with namesbeginning SYS_IL0000 for the tables that have BLOB columns. Can Isafely rebuild these, or should I leave Oracle to look after them? 3) Does Oracle automatically free up the space in the tablespace wherethe indexes used to be, once I move them? 4) Any gotchas? TIANick

Source is Usenet: comp.databases.oracle.misc
Sign in to add a comment

Answer score: 5
06/12/2018 11:47 - Nick, Any user with ALTER ANY INDEX can rebuild an index. This wouldinclude all users with the DBA role not just SYS and SYSTEM.

You cannot move a LOB index via an alter index statement. The LOBindex goes with the table. Check out the following link http://www.freelists.org/archives/oracle-l/09-2004/msg01063.html HTH -- Mark D Powell --

Source is Usenet: comp.databases.oracle.misc
Sign in to add a comment

eDiscover
Helpforce eDiscover provides technical articles updated each dayHelpforce eDiscover RSS feed contains the latest technical articles in RSS
Click the logo to go back to the main page
Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS

Type your comment into the box below