You are here: Home // Oracle 11g // 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 match existing string block size [string]

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. See the solution below.

Error solution: 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.

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: hentai game cg Filtr Fiaam SEAT IBIZA II (Fiaam) depilacja laserowa bielsko manuka Wczasy w Świnoujściu