Contents
What are the mandatory tablespaces in Oracle 11g database?
Oracle comes with the following default tablespaces: SYSTEM , SYSAUX , USERS , UNDOTBS1 , and TEMP . The SYSTEM and SYSAUX tablespaces store system-generated objects such as data dictionary tables. And you should not store any object in these tablespaces.
What are the mandatory tablespaces that are created at the time of database creation?
The three tablespaces that you can create at database creation time are the Undo tablespace (which defaults to the name in A if none is given and automatic undo is used), a default temporary tablespace, and the system tablespace (SYSTEM is the only one that is mandatory).
Which of the following tablespaces are required in an installation of Oracle database 12c?
A basic installation requires three tablespaces totalling 8 gigabytes of space in addition to the space required for the Oracle database software.
What is a synonym in Oracle?
A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects. You generally use synonyms when you are granting access to an object from another schema and you don’t want the users to have to worry about knowing which schema owns the object.
What do you need to know about Oracle 11g tablespace management?
Oracle 11g Tablespace management is one of the important tasks of a database administrator.Before learning how to manage tablespaces lets understand what is tablespace. A tablespace is one of the logical structure of the database. The database’s data is collectively stored in the database’s tablespaces. Tablespace contains one or more datafiles.
What is the SYSAUX tablespace in Oracle 10 g?
This is an auxiliary tablespace to the SYSTEM tablespace. The SYSAUX tablespace contains data for some components and products, reducing the load on the SYSTEM tablespace. Every database using Oracle Database 10 g release 1 (10.1) or later must have a SYSAUX tablespace.
A tablespace in an Oracle database consists of one or more physical datafiles. A datafile can be associated with only one tablespace and only one database. Oracle creates a datafile for a tablespace by allocating the specified amount of disk space plus the overhead required for the file header.
Which is the default table space in Oracle?
Components that use SYSAUX as their default tablespace during installation include Automatic Workload Repository, Oracle Streams, and Oracle Text. For more information, see Oracle Database Administrator’s Guide. This tablespace stores temporary data generated when processing SQL statements.