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.

Walkthrough: Configuring and managing space

Walkthrough: 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

Walkthrough: Configuring and managing space

“

- [Instructor] So managing space and ensuring that that errors don't arise for applications and users due to space constraints is really important. The goal is to help you put what you learned in the videos with logical and physical structures that are part of Oracle space management to use. First questions I of posed to you were adjusting the user's table space to have unlimited space. How would you actually do that? So I'm going to log into my database, and I am at the container level for the user's table space. And to do so, I need to first check that database file and find out, is it already set to auto extend? (typing) This is the DBA data files view that we're pulling this from. And because these are files that are on the file system, they are cap sensitive, and it's in small. Now you'll see that this is already set to this. But what you would want to do as part of this is be able to update. And the way that you do this is through alter data file commands, data file, you'd put…

Contents