This video lists the four unique tablespaces that Oracle automatically creates as part of the installation process. Learn about their crucial function for database operation.
- [Narrator] Oracle has some very special tablespaces…that it will create automatically out of the box…during installation.…Oracle uses these tablespaces for various…of its own purposes.…Let's review them.…The first two tablespaces created out of the box…by Oracle are the SYSTEM and SYSAUX tablespaces.…The take-away here?…These are not for us, do not create your own tables…inside those special tablespaces.…The SYSTEM tablespace, for example,…holds the entire Oracle data dictionary.…
All of the metadata about our database…is stored inside the SYSTEM tablespace.…If you lose the SYSTEM tablespace,…you lose your entire database.…That's how important it is.…We also have a special tablespace…known as the UNDO tablespace.…It also is managed by the Oracle database…and is not intended for us to create tables in.…What does the UNDO tablespace do?…Well, every Oracle database…has a method of maintaining information…that is used to roll back or undo changes in the database.…
For example, what happens if a user modified a row,…
After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Learning Relational Databases (2014)with Adam Wilbert2h 39m Beginner
2. Instance Memory Pools
3. Instance Background Processes
4. Client Connections
5. Physical Database Structures
6. Mulitenant Database
7. Start and Stop the Database
8. Install Oracle 12c software
9. Create a Database Instance
Use DBCA to create a database14m 55s
10. Tools for Developers and DBAs
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.