Managing Tablespaces and Datafiles with Oracle
In Oracle, your application objects and codebase are all stored in tablespaces. Tablespaces comprise Data files. So knowing how to manage tablespaces and datafiles is an absolute imperative, especially if you’re a DBA.
What you'll learn
Once you’ve mastered Oracle’s architecture with the course, Understanding Database Architecture with Oracle, and learned to work with Oracle instances in the course, Managing Databases with Oracle, you pretty much have the Oracle essentials locked down.
In this course, Managing Tablespaces and Datafiles with Oracle, you'll start by understanding the purpose of tablespaces.
First, you'll explore how to rename a tablespace, and even change its mode of operation.
Next, you'll discover what happens when you no longer need a tablespace.
Finally, you'll learn how to view tablespace information, as well as how to move data files around.
By the end of this course, you'll have an understanding of how how to simplify the management of the underlying tablespaces and datatables with Oracle.
Table of contents
- Course and Module Introduction 1m
- Tablespaces and Datafiles 4m
- Understanding the First Four 3m
- Why We Need More Tablespaces 2m
- Creating Tablespaces 5m
- Renaming Tablespaces 0m
- Controlling Redo Generation 1m
- Making a Tablespace Read-only 1m
- Dropping Tablespaces 2m
- Oracle Managed Files 4m
- Bigfile Tablespaces 3m
- Resizing Tablespaces 3m
- Toggling Datafiles Offline and Online 3m
- Renaming and Relocating Datafiles Online 2m
- Temporary Tablespace 2m
- Default Permanent Tablespace 2m
- Course Summary 1m
About the author
I got my start in IT administrating an Oracle 10g database on Red Hat Linux. I've come a long way since and have used Linux everyday since 2012 both personally and professionally. As an independent consultant, I'm currently responsible for no less than forty Oracle databases running on Windows and Red Hat Servers. Perhaps the only thing I love almost as much as Linux is the Cloud and the many opportunities it provides. Linux has opened a lot of doors for me, and teaching it is my favorite pas... more