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
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what is logical system in sap basis
Query processing is slow(eg select query)how will u solve that
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what are the benefits of flashback feature?
how can you create a user-defined lock?
What are the different sql server versions you have worked on? : sql server DBA
how can you record information about current session?
how can you schedule a job in database?
How can you control the amount of free space in your index pages? : sql server DBA
how can you find out if a table can be redefined?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what are the types of connection load-balancing?