This module looked at a variety of new features and enhancements that make life easier for the DBA. You saw how to load data, shuffle tables around, and modify table structures without dropping the tables.
Now that you have completed this module, you should be able to:
List improvements to SQL*Loader
Load LOB data with SQL*Loader
Describe enhancements in table management
Relocate a table
Describe why and how to create a temporary table
Find and remove an unused column from a table
List new database limits
Workspace Manager is tightly integrated with the Oracle database. Oracle Database 10g Workspace Manager enhancements included the ability to export and import version-enabled tables, to use SQL*Loader to bulk-load data into version-enabled tables, to trigger events based on workspace operations, and to define workspaces that are continually refreshed.
Oracle Database 11g continues the stream of enhancements to workspaces, providing support for optimizer hints and more data maintenance operations on workspace-enabled tables.
Oracle Glossary Terms
You were introduced to the following term in this module.
Temporary table: a table that is created like a regular table, but whose data is temporary and private (seen only by the user that inserts the data, even if multiple users are using the same temporary table at once)
In the next module, you will review the concept of table joins and see how Oracle implements outer joins and adds new functionality with special query formats.