From: Vitaly Sikolenko Subject: Re: DB_BLOCK_SIZE: Misinformation? Date: 1997/08/08 Message-ID: <33EB11D1.4DAA3F69@ru.oracle.com>#1/1 References: <19970801154300.LAA05075@ladder01.news.aol.com> To: SatarNag X-Priority: 3 (Normal) Organization: Oracle C.I.S. Reply-To: vsikolen@ru.oracle.com Newsgroups: comp.databases.oracle.server SatarNag wrote: > In regards to changing the DB-Block_Size without re-creating your > database, I must have been misinformed, Upon looking up in my > documentation, it says it must be done on the creation of the > database. I > have just completed the Oracle DBA master's coarse (Oracle 7.3), > offered > by Oracle....And in my notes, i wrote down that the Block Size can be > changed and that the database will start useing the new size and will > adjust accordingly...I wrote this down cause I thought it was nice > that it > can be done. Maybe it still can be done, and that it's not documented > in > the books. I apoligize if I am mistaken. Maybe it's in Version 8??? > > Satar Naghshineh You can't change the db_block_size: it would lead to full restructuring of the database. -- Vitaly Sikolenko Senior Sales Consultant Server & Gateways ORACLE C.I.S. Moscow Russia E-mail: vsikolen@ru.oracle.com The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.