How can you rebuild an index?

Answer Posted / ravikiran koppisetty

ALTER INDEX INDEXNAME REBUILD

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2385


i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

1635


how can you record information about current session?

493


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1535


How do you open a cluster administrator? : sql server DBA

577






what are the types of connection load-balancing?

559


How do you troubleshoot errors in a sql server agent job? : sql server DBA

561


what is the diffrence between core dba and apps dba?

2082


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2100


Where do you find the default index fill factor and how to change it? : sql server DBA

552


internal architecture

1753


What are the commands used in dcl? : sql server DBA

574


how can you schedule a job in database?

595


how can you communicate with operating system files from oracle?

556


how can you initialize log miner?

573