Regular Table Operations
You will, doubtless, at some point need to reorganize a table, move a table from one tablespace to another, redefine an entire table or portions of tables, or perform other interesting tasks. This section discusses these operations.
Reorganizing Tables
Reorganizing tables can eliminate row migration both offline (as you have been able to historically) as well as online.
Redefining Tables
Occasionally you will need to redefine a table that is in production. Historically, you would have needed to lock the table in shared mode to perform this action. In effect, this shuts out all DML access. In Oracle 9i, you can now redefine tables while the database is online, and the table is accessible to DML operations for the duration ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) 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.
