Answer / ramesh

ALTER INDEX <Index> REBUILD ONLINE;

one Should Configure a script to Rebuild indexes at Regular
intervals for the needy

Answer / ehtesham malik

Alter index index_name REBUILD COPMUTE STATISTICS

Answer / deepak

alter index <indexname> rebulid;

Answer / ravikiran koppisetty

ALTER INDEX INDEXNAME REBUILD

Answer / guest

dbcc dbreindex ('table_name' [, index_name [,
fillfactor ]]) [WITH NO_INFOMSGS]

Answer / kishore

DBCC dbreindex('tabname','indexname','fillfactor')

how can you find out if a table can be redefined?

0 Answers   Oracle,

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.

0 Answers  

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

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

0 Answers  

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

How would you determine the time zone under which a database was operating?

2 Answers  

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

Explain the use of table functions.

1 Answers  

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,