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

Thread: tablespace..

Hybrid View

  1. #1
    Join Date
    Sep 2007
    Posts
    19

    tablespace..

    hi,

    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
    Posts
    2,828
    Hi

    Metalink Note:138242.1

    regards
    Hrishy

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