Rebuilding a Table

Sometimes DBAs may need to rebuild a table. For example, they might simply want to relocate a table to a different tablespace or rebuild it with different storage parameters. They might need to drop a column or reorder the columns (and their Oracle version may not support these capabilities natively). Whatever the reasons, the task of rebuilding a table is very complex. You need to maintain all the same qualities, so you must preserve definitions for constraints, indexes, views, triggers, grants and synonyms. Plus you must preserve the data as well. The SQL to accomplish such a relatively simple task is quite substantial.

TOAD’s Rebuild Table screen makes short work of generating the complete script necessary for rebuilding ...

Get TOAD® Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.