Answer Posted / rrr2009cse@gmail.com
while moving tables to the other tablespace the indexes has been unused due to movement of segments(tables). to reuse previous index on a table has to be rebuild
alter index indxname tablespace
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
how can you communicate with operating system files from oracle?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Why does Oracle not permit the use of PCTUSED with indexes?
Explain about your sql server dba experience? : sql server DBA
What is dcl? : sql server DBA
how to restore files with rman?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the different sql server versions you have worked on? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
which background process invoke at the time of upgradation tell me???
how can you schedule a job in database?
What is fill factor? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What are the different types of upgrades that can be performed in sql server? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA