What is Tablespace? Explain types of tablespace.
A databse consists of one or morelogical storage units is called a tablespace. Each tablespace in an OracleDatabase consists of one or more data files. A database typically contains atleast one tablespace. Within the database, the table is same as a folder onhard disk of a computer. Every oracle database has a tablespace named SYSTEM,which is created automatically when the Oracle is installed. The SYSTEMtablespace is the default location of all objects when a database is firstcreated. Tablespaces can be created, dropped(deleted) and merged, just as canthe folders on the hard disk of a computer.
Syntax to create a tablespace:
CREATE TABLESPACE<tablespace_name> DATAFILE <path> SIZE <int>
Syntax to delete a tablespace:
DROP TABLESPACE<tablespace_name>
Types of tablespace:
SYSTEM tablespace
TEMP tablespace
Tools tablespace
USER tablespace
DATA and INDEX tablespace
ROLLBACK tablespace
A databse consists of one or morelogical storage units is called a tablespace. Each tablespace in an OracleDatabase consists of one or more data files. A database typically contains atleast one tablespace. Within the database, the table is same as a folder onhard disk of a computer. Every oracle database has a tablespace named SYSTEM,which is created automatically when the Oracle is installed. The SYSTEMtablespace is the default location of all objects when a database is firstcreated. Tablespaces can be created, dropped(deleted) and merged, just as canthe folders on the hard disk of a computer.
Syntax to create a tablespace:
CREATE TABLESPACE<tablespace_name> DATAFILE <path> SIZE <int>
Syntax to delete a tablespace:
DROP TABLESPACE<tablespace_name>
Types of tablespace:
SYSTEM tablespace
TEMP tablespace
Tools tablespace
USER tablespace
DATA and INDEX tablespace
ROLLBACK tablespace
No comments:
Post a Comment