O'Reilly logo

OCA: Oracle 10g™ Administration I: Study Guide by Matthew Weishan, Joseph C. Johnson, Bob Bryla, Chip Dawes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

3.5. Summary

In this chapter, you learned about the purpose of tablespaces and datafiles. You found out how to create and manage tablespaces as well as how Oracle stores some schema objects as segments in extents and data blocks.

You learned how to create and modify tables, indexes, constraints, views, and sequences. We covered deferred constraint checking and how to configure foreign key constraints to support either deferrable or not deferrable implementations.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required