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

ORA-06737: TLI Driver: connection failed

1 Answers  


ORA-16726: the external condition supplied to resource manager is invalid

1 Answers  


QSM-01111: no partition key or partition marker found in MV, string

1 Answers  


TNS-02515: Encryption/crypto-checksumming: unknown control type

1 Answers  


ORA-02466: The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.

1 Answers  






ORA-01973: Missing change number

1 Answers  


ORA-26025: SKIP_INDEX_MAINTENANCE option requested

1 Answers  


ORA-30379: query txt not specified

1 Answers  


ORA-30114: error when processing from command line

1 Answers  


TNS-04203: Trace Assistant Usage ERROR: Invalid options

1 Answers  


IMG-00921: threshold out of range

1 Answers  


ORA-02453: duplicate HASH IS specification

1 Answers  


Categories