1

Is there any way to configure Oracle 11g's default block size on installation? I have tried Oracle 11g r2 and r3, during both installations block size is 8k and it is disabled (and can not be modified).

I shall restore a data-pump backup from a 16k block size database, so I need to make mine 16k too.

I know I can do this by assigning block size to individual tablespaces (data files), but I am looking for a way to set the default data file size on the whole oracle instance.

Improve this question
1
  • 1
    11g r3? I'd like to see that!
    – Colin 't Hart
    Commented May 11, 2014 at 20:56

1 Answer 1

Reset to default
1

You need to choose "Custom Database" in the "Select Template" screen of the Database Creation Assistant, and not one of the templates that includes datafiles as in those the block size is fixed and cannot be changed.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.