To add a user, use the CREATE USER command.
To remove a user, use the DROP USER command.
There is no ARCHIVE USER command. Instead, you'll want to use Oracle's export utility to generate a dump of all objects the user owns. This is done on the database server with the following command:
exp userid=system/manager file=my_user.dmp owner=my_userThe above signs on to the database with the SYSTEM user. The dump file will contain all objects owned by MY_USER.
This was first published in May 2007