标题: ORA-03221: Temporary tablespaces and temporary segments must have standard bl... [打印本页] 作者: admin 时间: 2016-7-24 11:15 标题: ORA-03221: Temporary tablespaces and temporary segments must have standard bl... ORA-03221: Temporarytablespaces 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 aDDL
statement that would result in the creation of a temporary segment in atablespace
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 tablespaceto a
temporary tablespace, ensure that it is of standard block size. (3) Ensure thatthe
user's temporary tablespace is a tablespace having the standard block size.