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?

TrackBack URI for this entry

Comments (0)

Subscribe to this comment's feed

Show/Hide comments

Show/Hide comment form