From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Assignment: Configuring and managing space

Assignment: Configuring and managing space - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Assignment: Configuring and managing space

“

- [Instructor] It's now time for an assignment on configuring and managing space. Got a couple questions here. We'll start with how do we adjust the USERS tablespace to have unlimited space? How do you verify that the change has been done to the datafile for the USERS tablespace? Third question is what are the names of the tablespaces, the size and megabytes each, and order them by largest to smallest? And which tablespace is using the most space? I do have a couple hints and callouts for this one. One of the hints is to calculate the amount of storage using megabytes to make it easily readable. Don't do it in bytes. Use the order by alias for the query on tablespace size, which is a new feature in Oracle 23c. And unlimited growth isn't the same as allocated space in a tablespace or datafile. Okay, it's time to do this assignment on your own, so I'll see you in the next walkthrough video.

Contents