Home » RDBMS Server » Server Administration » ORA-14520 Tablespace ### block size [8192] does not match existing object block size [16384]
icon5.gif  ORA-14520 Tablespace ### block size [8192] does not match existing object block size [16384] [message #210546] Thu, 21 December 2006 04:56 Go to next message
jorge.bellver
Messages: 2
Registered: December 2006
Location: Valencia (SPAIN)
Junior Member
Hi everyboy,
i'm trying to move a partition table to another tablespace with diferent block size, 16K to 8k, the data that the table contains is always less then 7K so i supose that i am not going to have any problem, but when i try i found this error, i read the message and i understand why, anybony knows how can i do it or some help about that??

Regards

Report message to a moderator

Re: ORA-14520 Tablespace ### block size [8192] does not match existing object block size [16384] [message #210575 is a reply to message #210546] Thu, 21 December 2006 06:32 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Hi,

Welcome on ORAFAQ

ORA-14520: Tablespace string block size [string] does not match existing object block size [string]

Cause: A DDL statement was issued that would require a tablespace of a block size different from the block size of the specified partitioned object to be assigned either: (1) As the object's default tablespace (or one of the object's partition-level default tablespaces, if composite partitioning is being used) OR (2) To one of the object's partitions/subpartitions.

Action: Specify a tablespace of the same block size as the partitioned object.


regards
Taj

Report message to a moderator

Re: ORA-14520 Tablespace ### block size [8192] does not match existing object block size [16384] [message #210603 is a reply to message #210575] Thu, 21 December 2006 08:49 Go to previous message
jorge.bellver
Messages: 2
Registered: December 2006
Location: Valencia (SPAIN)
Junior Member
Hi user52,
i knew this message, thxs but
i know that the problem is that is not the same block size,
but i want to change the block size of the tablespace then i try to move the partition to the new tablespace with the new block size, is just to take some space that i need, so th problem is that i cannot do it by this way, i heard something about the problem is the version and some patch probably some pacht can fixed my problem, my question is if someone do it before, move a table to another tablespace with less block size,
thxs again

Report message to a moderator

Previous Topic: Impact on file system
Next Topic: ORA-01552, plz help it's urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:38:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.