Database Reference
In-Depth Information
Before Oracle 10g there was only one tablespace, that tablespace
is now called smallfile tablespace (SFT). SFT is the default
tablespace type. All the CREATE/ALTER TABLESPACE
statements we saw at the start of the chapter, Oracle took them as
SFT. You can make BFT as a default tablespace type in your
database by using the following statement.
ALTER
DATABASE
SET
DEFAULT
BIGFILE
TABLESPACE;
After the execution of this statement, every time you use the
CREATE/ALTER TABLESPACE statement, Oracle will take it
as BFT unless you specify SMALLFILE clause explicitly or
change it back to SFT using the following statement.
ALTER
DATABASE
SET
DEFAULT
SMALLFILE
TABLESPACE;
Other Database Operations
Besides working with tablespaces, using the SQL statements we
can manage database access by creating new users, altering
existing and assigning them system and/or object privileges,
roles, profiles. All this and much more are already covered in the
SQL chapter and manual database design technique. Now let's
have a look on how we can manage Oracle database using
Oracle Enterprise Manager Database Control.
Search WWH ::
Custom Search