Answer Posted / mohapatra.gouranga@gmail.com
> Index rebuild nothing of Drop and re-create of Index.
> Is usefull to move index from one tablespace to other.
> Do not do if not necessary.
> In case of migration, do only validate structure for the
indexex.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What are the operating modes in which database mirroring runs? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what is a crs resource?
What are statistics, under what circumstances they go out of date, how do you update them?
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
what are the types of connection load-balancing?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What types of replication are supported in sql server? : sql server DBA
what are the performance views in an oracle rac environment?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what is the use of recording information about current session?
Can you redefine a table online?