The details to do this vary depending on your hardware platform. It is a little different on Unix/Linux and Windows. But to make it easier, just fire up the Database Configuration Assistant (DBCA) that was installed when you installed the Oracle software. On Unix/Linux, this utility is found in $ORACLE_HOME/bin. On Windows, there will be a shortcut somewhere under Start->Programs->Oracle.
This was first published in December 2003