数据库与表空间有什么区别? [英] Database vs tablespace, what's the difference?

问题描述

在oracle中，数据库和表空间之间有什么区别?

In oracle what's the differences between a database and a table space?

推荐答案

一些术语:

Oracle将数据库定义为在Oracle系统上找到的文件集.这意味着Oracle系统中的所有数据都在这些数据库文件中，这些文件通常称为数据文件".数据库中还有其他文件，例如参数文件和重做日志.

Oracle defines a database as the set of files that you find on your Oracle system. This means all data in your Oracle system is in these database files, commonly known as "data files". There are other files in the database such as parameter files and redo logs.

另一方面，实例由Oracle数据库使用的进程和内存区域组成. 数据库和实例共同构成了数据库系统. (有关详细信息，请参见《 Oracle概念指南》 )

On the other hand, an instance consists of the processes and memory areas that Oracle database uses. Together, a database and an instance make up a database system. (For more information, see the Oracle Concept guide)

从逻辑上讲，您将需要在该数据库中定义不同的空间.这是通过表空间完成的(请参见 Oracle概念指南).一个表空间通常由一个或多个数据文件组成.使用CREATE TABLE定义表时，可以指定应在哪个表空间中创建表.例如，这使您可以分离同一数据库系统上的不同应用程序.

Logically, you will want to define different spaces within that database. This is done via tablespaces (see Oracle Concept guide). A tablespace usually consists of one or more data files. When you define a table with CREATE TABLE, you can specify in which tablespace the table should be created. This allows you to seperate different applications on the same database system, for example.

Oracle Concepts指南是此类问题的绝佳信息来源.关于数据文件和表空间的方式，看到此图组成.

The Oracle Concepts guide is an excellent source of information for questions like these. See this picture on how data files and tablespaces are composed.

这篇关于数据库与表空间有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！