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.
Dig Deeper on Oracle DBA jobs, training and certification
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.