Manipulating Tablespaces and Data Files with OEM

As always, when maintaining anything with OEM, you have to attach to a launched console, expand the databases folder, and find the database from the list that you will be working with.

Because we are working with tablespaces and data files, and both are considered to be storage, you need to find and expand the storage section.

Changing the Storage Settings

To change the storage settings, you need to expand the tablespaces folder, find the tablespace to which you need to make alterations, and right-click the tablespace. From the resulting pop-up menu, choose View/Edit Details, click the storage tab in the popped-up window, make any changes that you need to make, and click the Apply button; then ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) 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.