From the course: Oracle Database 12c: Administration
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Datafiles and tablespaces - Oracle Database Tutorial
From the course: Oracle Database 12c: Administration
Datafiles and tablespaces
- [Instructor] Let's start our Oracle Database storage discussion by talking about the Oracle Datafiles. Lucky for us, they're also the most complex type of Oracle file we need to learn about. So be sure to have a nice cup of coffee on hand, as we are about to go deep down the rabbit hole on how Oracle manages storage. The Oracle Database Datafiles actually contain all of the user, or application, data in our database. Tables, rows, they are stored inside datafiles. Indexes, yep, inside our datafiles. Database metadata, such as the users that have been created and their permissions, or views, and stored procedures? Yep, all database data, as well as metadata, is stored inside the datafiles. That is why the datafiles are such an important component for Oracle database storage. You lose them, you lose your database. Each Oracle database will contain several datafiles. Some are created automatically when we install Oracle, and some are created by us, or users, to store application data…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.