DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: tablespace..

  1. #1
    Join Date
    Sep 2007



    i wanted to create a tablespace with 32k blocksize.so....

    i tryed to create a tablespace with 32k blocksize in 10g(windows)

    but could not able to create tablespace with 32k blocksize since my database is already configured for 8k blocksize,

    which will be in INIT.ORA file as "db_block_size=8192".

    then i tryed to create new database itself with 32k blocksize, i received this error.

    ORA-00374 : Parameter db_block_size=32768 invalid.

    Must be a multiple of 512 in the range [2048...16384]

    i want to know,is the BLOCK SIZE is platform/OS dependent.?

    if NO then why im i unable to create database with 32k blocksize in windows xp?

    if YES,can u send me how to check the blocksize of OS and which OS supports which blocksizes ?

  2. #2
    Join Date
    Jan 2001

    Metalink Note:138242.1


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width