Building the Sample Application Database

Chapter 1, “Introducing Oracle9i,” discussed the Oracle9i architecture—the relationship of physical computer files being created and assigned to Oracle9i tablespaces. Chapter 2, “Fundamentals of the SQL Language,” illustrated how to create these tablespaces and assign a computer file to them.

The tablespaces of an Oracle database are much like the folders or directories found on a PC in that they are storage areas for information. These tablespaces, folders, and directories are designed to help locate information or to locate information on different parts of the computer. For example, the 'bin' folder on a computer is typically used to store programs. Folders or directories such as data would be for information ...

Get Oracle9i™ Development by Example now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.