Using Storage Manager

Storage Manager, as you have probably already guessed, is used to manage the physical files and database structures related to storage of your data. You use Storage Manager to perform the following tasks:

1. Create a tablespace
2. Add a datafile to a tablespace
3. Create redo log groups
4. Create rollback segments
5. Take rollback segments, tablespaces, or datafiles offline
6. View or modify default storage parameters for a tablespace

Click the link below to practice using some of Storage Manager’s functionality.
Exploring Storage Manager.

1. You need to log into a database. Enter system in the username field and press Tab to advance to the password field. Type dogtoad in the password field and press Tab to advance to the service field. Next, tell Enterprise Manager the database to which you want to connect. Type coin in the service field and click the OK button.
2. This is the opening screen that you will see after logging in to your database. From here, you can click any of the items in the left pane to see information about that item. Click the close box in the upper right corner to exit.
3. Storage Manager displays a list of tablespaces on the right-hand side of the screen. From here, you can click any of the items in the left pane to see information about that item. Click the close box in the upper right corner to exit.
4. Clicking Datafiles causes Storage Manager to display a list of datafiles on the right-hand side of the screen. From here, you can click any of the items in the left pane to see information about that item. Click the close box in the upper right corner to exit.
5. Clicking Rollback Segments gets you a list of rollback segments. From here, you can click any of the items in the left pane to see information about that item. Click the close box in the upper right corner to exit.
6. A list of Redo Log files is being displayed on the right-hand side of the screen. From here, you can click any of the items in the left pane to see information about that item.

In later courses in this series, you will explore each aspect of Storage Manager’s functionality in greater detail. For now, go on to the next lesson and learn about Security Manager.