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 would you extract DDL of a table without using a GUI tool?
What is the difference between dropping a database and taking a database offline? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
how can you find out if a table can be redefined?
What is fill factor? : sql server DBA
Query processing is slow(eg select query)how will u solve that
what do you understand by fine-grained auditing?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you process messages in order asynchronously?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
what is the use of recording information about current session?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how does an oracle clusterware manage crs resources?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.