在上面的查询中表空间有什么用？ [英] What is the use of tablespace in the above query?

问题描述

CREATE TABLE ts_pcode_tb_incase
    TABLESPACE USERS
    AS
    SELECT *
      FROM ts_pcode_tb;

以上查询中表空间的用途是什么？

What is the use of tablespace in the above query?

推荐答案

表空间是数据库中数据文件的逻辑组。数据库通常包含至少一个表空间，通常包含两个或更多。在数据库中，表空间的作用类似于计算机硬盘驱动器上的文件夹。

A tablespace is a logical group of data files in a database. A database typically contains at least one tablespace, and usually two or more. Within the database, the tablespace plays a role similar to that of a folder on the hard drive of a computer.

某些数据库程序（例如Oracle）会自动创建表空间称为SYSTEM，其中包含有关数据库的结构和内容的常规信息。小型数据库可以完全包含在SYSTEM表空间中，但是在大多数情况下，用户数据位于其他表空间中。

Some database programs, such as Oracle, automatically create a tablespace called SYSTEM that contains general information about the structure and contents of the database. A small database can be entirely contained in the SYSTEM tablespace, but in most cases, user data is placed in other tablespaces.

表空间中的文件通常具有一个共同的特征。例如，批发分销商的数据库可能包含名为ACCOUNTING，ORDERS，SHIPPING，SERVICE和SYSTEM的表空间。每个表空间可能只包含一个数据文件，数千个文件或两者之间的任何内容。可以创建，删除和合并表空间，就像创建计算机硬盘上的文件夹一样。

The files in a tablespace usually share a common characteristic. For example, a database for a wholesale distributor might consist of tablespaces entitled ACCOUNTING, ORDERS, SHIPPING, SERVICE, and SYSTEM. Each tablespace might contain only one data file, or thousands of files, or anything in between. Tablespaces can be created, deleted, and merged, just as can the folders on the hard drive of a computer.

参考...

这篇关于在上面的查询中表空间有什么用？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！