ORA-03221: Temporary tablespaces and temporary segments must have standard block size

ORA-03221: Temporary tablespaces and temporary segments must have standard block size
Cause: An attempt was made to do one of the following : (1) create a temporary tablespace with a non-standard block size or, (2) alter an existing permanent tablespace of non-standard block size to a temporary tablespace or, (3) issue a DDL statement that would result in the creation of a temporary segment in a tablespace of non-standard block size.
Action: (1) If creating a temporary tablespace, do not specify a block size different from the standard block size. (2) If altering an existing permanent tablespace to a temporary tablespace, ensure that it is of standard block size. (3) Ensure that the user's temporary tablespace is a tablespace having the standard block size.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:38

ORA-03221：临时表空间和临时段必须具有标准块大小,
.原因：尝试执行以下操作之一：（1）创建具有非标准块大小的临时表空间，或（2）将非标准块大小的现有永久表空间更改为临时表空间，或者（ 3）发出一个DDL语句，这将导致在非标准块大小的表空间中创建一个临时段。,
.操作：（1）如果创建临时表空间，请不要指定与标准块大小不同的块大小。（2）如果将现有永久表空间更改为临时表空间，请确保其具有标准块大小。（3）确保用户的临时表空间是具有标准块大小的表空间。,
.

aiaiDBA

13718043309

010-86462881

ORA-03221: Temporary tablespaces and temporary segments must have standard block size

1 个回答

相似问题