ORA-14522: Partition-level default tablespace string block
size [string] for string string does not match existing
string block size [string]



ORA-14522: Partition-level default tablespace string block size [string] for string string does not..

Answer / guest

Cause: A DDL statement was issued that would require
creation of a new subpartition in one of the partition-level
default tablespaces of an existing composite partitioned
object. However, the partition-level default tablespace
block size does not match the block size of the partitioned
object.

Action: Either (1) Modify the partition-level default
tablespace of the appropriate partition of the partitioned
object to a tablespace of the same block size as the object
and then retry the DDL command, OR (2) Ensure that
tablespaces of the correct block size are specified for all
new subpartitions being created.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02065: illegal option for ALTER SYSTEM

1 Answers  


LFI-01005: Unable to fill buffer.

1 Answers  


ORA-02427: create view failed

1 Answers  


ORA-30393: a query block in the statement did not rewrite

1 Answers  


ORA-06816: TLI Driver: could not set the SPX SAP address

1 Answers  






ORA-38477: attribute set cannot be derived from an evolved type or a subtype.

1 Answers  


ORA-25400: must replay fetch

1 Answers  


ORA-31493: could not prepare session for LogMiner session

1 Answers  


NNO-00301: server will shut down in number seconds

1 Answers  


ORA-14194: only one subpartition may be rebuilt

1 Answers  


ORA-01910: TABLES keyword expected

1 Answers  


ORA-14024: number of partitions of LOCAL index must equal that of the underlying table

1 Answers  


Categories