ORA-14521: Default tablespace string block size [string] for
string string does not match existing string block size [string]



ORA-14521: Default tablespace string block size [string] for string string does not match existing ..

Answer / guest

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

Action: Either (1) Modify the default tablespace 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 partitions/subpartitions being created.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

IMP-00082: Error during conversion ROWID from string format to internal

1 Answers  


ORA-01277: file 'string' already exists

1 Answers  


SQL-02141: Collection descriptor has not been allocated

1 Answers  


ORA-06906: CMX: cannot get maximum packet size from CMX

1 Answers  


ORA-29815: object being associated is not present

1 Answers  






IMG-00002: unrecoverable error

1 Answers  


ORA-12073: request cannot be processed

1 Answers  


ORA-36274: (XSCGMDLAGG05) The operator used in this equation needs a weight variable.

1 Answers  


ORA-30464: no summaries exist

1 Answers  


NID-00441: All previous backups and archived redo logs for this database are unusable.

1 Answers  


ORA-00964: table name not in FROM list

1 Answers  


ORA-02344: cannot revoke execute on a type with table dependents

1 Answers  


Categories