Rebuild Multiple Objects
One task that always seems to need doing at some point in any database is rebuilding or reorganizing objects. In fact, Oracle has provided a powerful PL/SQL package for handling this task. Unfortunately, the DBMS_REDEFINITION package is far too complex for casual use. And remember, it will re-create your objects—which means a wrong step could lose actual data as well as the objects. What you really need is a simple, effective, and safe interface into this complex package. Toad offers its Rebuild Multiple Objects screen for this purpose. With this facility, even the greenest novice can quickly and safely rebuild database objects like a pro.
To launch the Rebuild Multiple Objects screen, choose Main Menu → Database → Optimize ...
Get Toad for Oracle Unleashed 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.
