Database Reference
In-Depth Information
SHUTDOWN NORMAL
The NORMAL clause in the SHUTDOWN command is default
i.e. if you just execute SHUTDOWN Oracle will take it as
SHUTDOWN NORMAL. As a result of this command, no new
user is allowed to make a connection with Oracle Instance. The
Instance will wait for each user to disconnect and then closes the
database, dismounts it onto itself and shuts down itself.
SHUTDOWN IMMEDIATE
As a result of this command, no new user connections are
accepted. All the connected users will get disconnected. Oracle
Instance will roll back all uncommitted transactions. Closes the
database, dismounts the database and shuts down itself.
SHUTDOWN TRANSACTIONAL
The result of this command is the same as SHUTDOWN
IMMEDIATE except that Oracle Instance waits for the
connected users to complete the transactions before
disconnecting them.
SHUTDOWN ABORT
As a result of this command, everything shuts down abruptly.
Oracle Instance terminates all connected users regardless of SQL
statements under process. Terminates itself immediately and will
not rollback uncommitted transactions. Instance recovery is
needed when you start the database next time.
Manual Database Design: Step 6
Issue the CREATE DATABASE Statement
CREATE DATABASE statement is used to create the database.
It has lots of clauses and it can be better understood if we first
look at its syntax and then real world examples. The syntax for
CREATE DATABASE statement is provided below.
Search WWH ::




Custom Search