Because, you left db_16k_cache_size parameter to the default value of 0 (zero).
- Kirti --- dba1 mcc <[EMAIL PROTECTED]> wrote: > I tried to create tablespace with 16K (default on my > init.ora blocksize =8k). I have error happen. The > database version is 9.2.0.4. > > SQL> create tablespace "index1" logging datafile > '/u0/oradata/leg92/index1.dbf' size 20m > 2 blocksize 16384 > 3 autoextend on > 4 next 1280k > 5 maxsize unlimited > 6 extent management local > 7 segment space management auto > 8 uniform size 128k; > autoextend on > * > ERROR at line 3: > > > if I take out "blocksize 16384", then it work fine. > > SQL> create tablespace "index1" logging datafile > '/u0/oradata/leg92/index1.dbf' size 20m > 2 reuse autoextend on > 3 next 1280k > 4 maxsize unlimited > 5 extent management local > 6 segment space management auto > 7 uniform size 128k; > > Tablespace created. > > Does anyone know why?? > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
