DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2001

    DB_BLOCK_SIZE change

    Hi, I have just installed Oracle 9i and created an instance with db_block_size = 8192.. Can I modify this parameter to 16384 after the database has been created? I know that you cannot do this in previous versions of Oracle. I cannot seem to find this answer anywhere. Please help. Thanks.

  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    In 9i you can create additional tablespaces with a larger block size. However, if you just created the database, it would be better to recreate it with the larger block size. Practice makes perfect.
    this space intentionally left blank

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.