Database Reference
In-Depth Information
Figure 11-5. Syntax for Alter-Database Statement (continued)
There is also a Drop-Database statement that allows you to delete the database.
In order to use it you must have administrator privilege. Also, be aware that not all
component files are removed from the operating system when this command is issued.
As an alternative, you can use the DBCA to delete a database.
11.4 Tablespace Creation
In the Oracle environment, another database object that must be created as part of the
database preparation is a tablespace. A tablespace is the holding area for all database
objects (actually, the objects are stored in datafile(s) contained within the tablespace).
A database must have at least one tablespace, but typically has several. The following are
tablespaces which are typically found in a database:
System tablespace (prefixed SYSTEM): This is a default tablespace
used for system resources.
Temporary tablespace (prefixed TEMP): Used for intermediate
results such as internal sorts for user queries.
Tools tablespace (prefixed TOOLS): Used for Oracle
administrative tools.
Index tablespace (prefixed INDX): For storing and maintaining
indexes.
 
Search WWH ::




Custom Search