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-02247: no option specified for ALTER SESSION

1 Answers  


ORA-24330: internal OCI error

1 Answers  


RMAN-20504: corruption list not found in recovery catalog

1 Answers  


RMAN-08119: skipping backup piece handle string; already exists

1 Answers  


ORA-29297: The compressed representation is too big

1 Answers  






ORA-14324: values being added already exist in DEFAULT partition

1 Answers  


ORA-12827: insufficient parallel query slaves available

1 Answers  


ORA-19610: directory block string is corrupt

1 Answers  


IMP-00050: Dump file and log file cannot be identical

1 Answers  


ORA-06736: TLI Driver: server not running

1 Answers  


ORA-24377: invalid OCI function code

1 Answers  


TNS-03603: Encountered a node with a version eariler than SQL*Net 2.3

1 Answers  


Categories