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

TNS-02508: Encryption: server negotiation response in error

1 Answers  


TNS-04016: Connecting to string

1 Answers  


ORA-15186: ASMLIB error function = [string], error = [string], mesg = [string]

1 Answers  


DRG-12511: use ctx_ddl.create_stoplist to create stoplists

1 Answers  


ORA-09768: osnmgetmsg: could not read a message

1 Answers  






ORA-16136: Managed Standby Recovery not active

2 Answers  


ORA-27047: unable to read the header block of file

2 Answers  


ORA-16234: restarting to reset Logical Standby apply

1 Answers  


ORA-29309: export dump file was generated by different version of DBMS_PITR package

1 Answers  


Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

0 Answers   IBM,


LPX-00231: invalid character ~1u ('~2c') found in a Name or Nmtoken

1 Answers  


RMAN-06402: Oracle instance shut down

1 Answers  


Categories