Shutting Down and Restarting Databases
Maintaining a database often involves shutting it down. Only the
SYSDBA or the owner of a database (the user who created it) can shut it down. The user who shuts down the database then has exclusive access to the database.
Exclusive access to a database is required to:
- Validate and repair the database.
- Add or drop a foreign key on a table in the database.
- Add a secondary database file.
After a database is shut down, the database owner and SYSDBA are still able to connect to it, but any other user attempting to connect gets an error message stating that the database is shut down.