1.

Describe The Process Steps You Would Perform When Defragmenting A Data Table. This Table Contains Mission Critical Data?

Answer»

There are several ways to do this:
1) We can MOVE the table in the same or other TABLESPACE and rebuild all the indexes on the table.
alter table move this activity reclaims the defragmented SPACE in the table
analyze table table_name compute statistics to capture the updated statistics.
2)Reorg could be DONE by TAKING a dump of the table, truncate the table and import the dump back into the table.

There are several ways to do this:
1) We can move the table in the same or other tablespace and rebuild all the indexes on the table.
alter table move this activity reclaims the defragmented space in the table
analyze table table_name compute statistics to capture the updated statistics.
2)Reorg could be done by taking a dump of the table, truncate the table and import the dump back into the table.



Discussion

No Comment Found

Related InterviewSolutions