From the course: Oracle Database 12c: Administration
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Special Oracle tablespaces - Oracle Database Tutorial
From the course: Oracle Database 12c: Administration
Special Oracle tablespaces
- [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…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.