Chapter Summary

This chapter has explained the logical and physical database storage structures, including databases, tablespaces, data files, segments, extents, and data blocks.

ImageTablespaces are logical storage divisions within an Oracle database. You create and manage tablespaces by using the SQL commands CREATE TABLESPACE and ALTER TABLESPACE.

ImageEach tablespace has one or more data files to physically store its data. You can specify the names and properties of a tablespace's data files when you create the tablespace with the CREATE TABLESPACE command. ...

Get Hands-On Oracle Database 10g Express Edition for Windows 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.