Answer Posted / deepak
alter index <indexname> rebulid;
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
how can you enable flashback feature?
What is fill factor? : sql server DBA
what is a user-defined lock?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Why does Oracle not permit the use of PCTUSED with indexes?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how can you process messages in order asynchronously?
What are the commands used in dcl? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
what is the use of recording information about current session?
What are the different types of indexes available in sql server? : sql server DBA
which background process invoke at the time of upgradation tell me???