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 ...
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
