Oracle data storage structures

After completing this lesson, you should be able todo the following: Compare and evaluate the different storage structures Examine different data access methods Implement different partitioning methods

26p trinh02 28-01-2013 55 2   Download

Tablespaces and Data Files Databases, tablespaces, and data files are closely related, but they have important differences: An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database’s data. Each tablespace in an Oracle database consists of one or more files called data files, which are physical structures that conform with the operating system in which Oracle is running. A database’s data is collectively stored in the data files that constitute each tablespace of the database.

52p trinh02 28-01-2013 67 6   Download