Server Manager is Oracle's database administration tool. The graphical component of Server Manager (Server Manager/GUI) allows you to perform database administration
tasks with the convenience of a graphical user interface (GUI). The line mode component of Server Manager (Server Manager/LineMode) provides a line mode interface.
There is a GUI
version of Server Manager available that is currently only supported under UNIX, and only using X-Windows
. The GUI version provides the following extra functionality:
- A real-time monitoring function
- GUI screens to create and modify users, tables, indexes, tablespaces, and so forth.
Oracle is slowly winding down support for Server Manager, and is promoting Enterprise Manager as the GUI tool of choice for managing Oracle databases.
The command-line functionality of Server Manager has been folded into SQL*Plus, and
is no longer shipped or supported in Oracle.
In this course we will be using SQL *Plus because it can be used with all current releases of Oracle.
If you are using release Oracle 9i or above, the same commands should work from SQL*Plus as well.