O'Reilly logo

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing tablespaces

Now that we've looked at how space is stored within the database at a micro level, it's time to get some hands-on experience working with space management. We'll examine creating and modifying tablespaces and their storage characteristics.

Starting SQL Developer

When we need to add space to a database, we do so by creating tablespaces and their associated datafiles with SQL commands. We'll execute these commands using our SQL Developer tool, so we need to take a moment to set it up. To do this on Windows, we navigate to Start | All Programs | Oracle – Oradb11g | Application Development | SQL Developer.

If we execute this on Windows, we'll be presented with the following window asking us the path to the Java executable:

Here we ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required