Deleting a tablespace

To rename a tablespace:

1. Navigate to ‘Administration > Tablespaces’ in Enterprise Manager.

2. Enter the name of the tablespace that you want to rename and click ‘Go’ (figure 17).

3. In the ‘Results’ region, select the tablespace name and click ‘Delete’.

Figure -17 Tablespaces Window (Delete tablespace)

4. The ‘Delete Tablespace Window’ is displayed (figure 18) with a warning. Click ‘Yes’ button.

Figure -18 Delete Tablespace Window (Warning)

Frequently Asked Questions

1. What is a tablespace?
2. What is a datafile?
3. Which extent management method leads to faster free space allocation?
4. What is the meaning of an offline tablespace?
5. What is a bigfile tablespace?
6. What are tablespace thresholds?
7. What does the auto extend option in datafiles?
8. How do you create an undo tablespace using SQ Plus, iSQL plus and Enterprise Manager?
9. How to rename a tablespace using SQ Plus, iSQL plus and Enterprise Manager?
10. How to delete a tablespace using SQ Plus, iSQL plus and Enterprise Manager?

First Page: Oracle 10g Free Training - Managing Tablespaces