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



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

Post New Answer

More Oracle Errors Interview Questions

QSM-02188: named view in FROM list not supported for this type MV

1 Answers  


ORA-32819: AQ queue string must be a normal queue

1 Answers  


ORA-13241: specified dimensionality does not match that of the data

1 Answers  


TNS-04014: Current instance string is already started

1 Answers  


ORA-07282: sksaprd: string overflow.

1 Answers  






ORA-09314: sltln: error translating logical name

1 Answers  


IMG-00857: area list free failed

1 Answers  


ORA-00602: internal programming exception

1 Answers  


CLSR-00525: prsr initialization failed

1 Answers  


DRG-10839: invalid ORDER argument supplied to NEAR

1 Answers  


PLS-00244: Multiple declarations in foreign function formal parameter list

1 Answers  


ORA-00396: error string required fallback to single-pass recovery

1 Answers  


Categories