ORA-03221: Temporary tablespaces and temporary segments must
have standard block size
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-31069: Cannot apply typed changes to non-schema-based XMLType nodes
ORA-19019: Invalid context passed to DBMS_XMLGEN.GETXML
ORA-31491: could not add logfile to LogMiner session
IMG-00523: invalid process verb
ORA-01630: max # extents (string) reached in temp segment in tablespace string
IMP-00074: The constraints flagged by ALL_CONSTRAINTS.BAD will break in 2000 A.D.
ORA-31113: XDB configuration may not be updated with non-schema compliant data
ORA-09945: Unable to initialize the audit trail file
QSM-00770: the specified workload string is already referenced by task string
DRG-51200: open keymap failed for index id = string
ORA-28238: no seed provided
ORA-30034: Undo tablespace cannot be specified as temporary tablespace