创建数据库时不存在用户临时表空间。
No user temporary table Spaces exist when a database is created.
没有创建用户临时表空间。
临时表存储在用户临时表空间中。
所消耗的用户临时表空间中的空间将得到释放。
The consumed space in the user temporary table space will be freed.
要使用临时表，是不是要有用户临时表空间？
Then what the different between system temporary tablespace and user temporary tablespace?
数据库中定义了五个常规的表空间和一个临时表空间。
In the database, five regular tablespaces and one temporary tablespace are defined. The following table shows the details of all tablespaces.
对于经常用于执行排序操作的临时表空间，也应该这样。
The same is true for temporary tablespaces often used for performing sort operations.
确保系统目录和系统临时表空间中具有足够的自由空间。
Ensure that there is sufficient free space on the system catalog and the system temporary tablespaces.
然后，我们使用友好的DBA提供的默认用户临时表空间打开跟踪。
We then turn tracing on using the default user temporary table space provided by the friendly DBA.
DB 2同样总是需要一个也是4KB页面大小的系统临时表空间。
As well, DB2 always required a system temporary table space that had a 4 KB page size too.
至少应当创建一个用户临时表空间以允许定义已声明的临时表。
At least one user temporary table space should be created to allow the definition of declared temporary tables.
用户临时表空间： 用户临时表空间存储已声明的全局临时表。
User temporary table spaces: User temporary table spaces store declared global temporary tables.
临时表空间中的默认存储参数决定了临时段中区的分配原则。
Oracle automatically allocates this disk space called a temporary segment. Typically, Oracle requires a temporary segment as a database area for sorting.
用户临时表空间是可选的，默认情况下不会创建用户临时表空间。
User temporary table Spaces are optional and none are created by default.
随数据库创建的系统临时表空间的默认名为TEMPSPACE1。
您应当创建一个或多个USER临时表空间来存储临时表的数据。
You should create one or more USER temporary table spaces for storing data of temporary tables.
IBMTEMPGROUP -用于系统临时表空间的默认数据库分区组。
IBMTEMPGROUP is - default database partition group for system temporary tablespaces.
对于DB 2 9.7，大型表空间和临时表空间的大小限制增加了4倍。
For DB2 9.7, the limits on the size of large and temporary table Spaces have been increased four-fold.
为了使用该例程，DB 2V8.2.2中需要一个8KB页面的用户临时表空间。
To use this routine in DB2 V8.2.2 requires an 8 KB page user temporary table space.
值得注意的是，临时表空间和空闲dm s盘区(extent)不是备份镜像的一部分。
It is also worth noting that temporary table Spaces and free DMS extents are not part of the backup image.
一个名为TbPSPACE1的系统临时表空间，用作某些操作的临时存储空间。
A system temporary table space named TEMPSPACE1, which is used as a temporary storage area for certain operations.
为应用程序堆、语句堆、缓冲池和临时表空间这些区域中的本地处理调优联邦系统。
Tune the federated system for local processing in the areas of application heap, statement heap, buffer pool, sort heap, and temp tablespace.
下面的脚本给出了一个例子，我们可以对其进行更改，从而在自己的环境中创建一个用户临时表空间。
The script below shows an example, which you can modify to create a user temporary table space in your environment.
我们记得为了要使用临时表，数据库中必须存在一个用户临时表空间(默认情况下没有)。
Recall that in order to use temporary tables, a user temporary table space must exist in the database (none exists by default). Here's how you would create such a table space.
为了构建这个日志框架，需要数据库管理员帮我们设置存储过程的日志目录并创建一个用户临时表空间。
In order for you to set up the logging framework, you will need help from your database administrator to set up the stored procedure logging directory and a user temporary table space.
表空间包括常规表空间、长表空间(用于lob数据)、用户临时表空间和系统临时表空间。
Table Spaces can be regular, long (for LOB data), user temporary, and system temporary.
没有必要拥有多个具有相同页大小的临时表空间，通常只需一个具有最大页大小的临时表空间就够了。
There is no reason to have more than one temporary table space of the same page size, and usually one with the largest page size is sufficient.
所有DB 2表空间都可以使用这个选项，包括系统表空间和临时表空间，以及数据库管理的表空间。
This option is available for all DB2 tablespaces, including system and temporary tablespaces and database managed tablespaces.
每一个DB 2数据库都至少包含一个分类表空间，一个或多个用户空间，以及一个或多个临时表空间。
Each DB2 database contains at least one catalog table space, one or more user table Spaces, and one or more temporary table Spaces.
考虑对所有小于52kb的表进行自动表重组，在线执行所有索引重组，并在重组时使用系统临时表空间。
Consider all tables for automatic table reorganization that are smaller than 52kb, perform all index reorganizations online, and use a system temporary table space when doing reorganization.
应用推荐