Oracle - How to delete an Oracle applications user? posted by
Babu Kunwar
How to delete an Oracle applications user?
By executing query
DROP user user_name CASCADE;
We need to write cascade because we cannot drop a user by writing simply DROP
user user_name if the user holds some objects such table, view, procedures. If
the user does not hold any objects then we can drop him without cascade. But if
it occupies some object we need to first drop that objects then only we can
delete the user.
More links
Why and when should I backup my database?
What strategies are available for backing-up an Oracle database?
Difference between online and offline backups.
Difference between restoring and recovering
Explain how to backup a database using the export utility
Explain how to put a database into ARCHIVELOG mode
Explain how to do off-line database backups..........
|
