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

RMAN-06054: media recovery requesting unknown log: thread string seq string lowscn string

1 Answers  


ORA-25330: PL/SQL associative arrays may not be used with AQ array operations

1 Answers  


KUP-04035: beginning enclosing delimiter not found

1 Answers  


ORA-36261: (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J.

1 Answers  


SQL*Loader-00938: partition load requested and string has enabled triggers or constraints

1 Answers  






KUP-04071: record discarded from file string

1 Answers  


NNL-01070: System parameter file name: string

1 Answers  


ORA-09322: slpdtb: unable to convert packed decimal to binary

1 Answers  


ORA-31075: invalid string declaration in XML Schema

1 Answers  


TNS-01178: Trace Level is 0. Trace file/directory unchanged

1 Answers  


ORA-24050: subscribers are not supported for exception queue string

1 Answers  


PLS-00152: POINTER type may only reference an object type.

1 Answers  


Categories