Expanded Library

Managing Tablespaces and Datafiles with Oracle

by Agaba Philip

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.

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

Ready to upskill? Get started