Re: weekend-fun with 11.2.0.2
- From: Jeremiah Wilton <jwilton@xxxxxxxxxxxxx>
- To: martin.a.berger@xxxxxxxxx
- Date: Fri, 17 Dec 2010 09:57:40 -0800
On Dec 17, 2010, at 9:29 AM, Martin Berger wrote:
If anyone want to have fun, just run this simple testcase:
use your 11.2.0.2 rdbms binaries (linux and hp-ux tested, but others
will also work).
create a small pfile:
db_name=test
db_block_size=2048
db_create_file_dest=/tmp
set any ORACLE SID and run
create database character set al32utf8;
I'd like to see your results ;-)
(I can give some more infos, do not waste time for investigations)
Wow that's broken. 2K block size doesn't really seem like much of an
edge case. 8k block size works fine, but you already know that.
SQL> create database character set al32utf8;
create database character set al32utf8
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/doptim.bsq' near
line 416
ORA-00604: error occurred at recursive SQL level 1
ORA-01429: Index-Organized Table: no data segment to store overflow
row-pieces
Process ID: 2246
Session ID: 87 Serial number: 3
Removed db_block_size from the pfile, and"
SQL> create database character set al32utf8;
Database created.
--
Jeremiah Wilton
http://www.bluegecko.net
Other related posts:
