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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.