Which platform has the largest possible data block size?

Hi all,

I've got an app that is creating a few reference tables. Some of them will only ever contain one row, with two 4-byte numbers. If I don't specify a storage clause, they pick up the default for the tablespace, which is fine if the default is reasonable. But sometimes it's not.

So I'd like to stick in the storage clause, using the smallest amount of space possible. BUT, as this app runs on Oracle on any platform, I need to worry about the size of the blocks on each platform, so I don't break the "Initial extent must be at least 2 blocks"/"Next extent must be at least 1 block" rules.

My idea is that if the platform with the largest Oracle block size is say OSBlah with a block size of 32K, I can make the create statement say

Create table Mytable ( ... ) storage (initial 64K next 32K ...);

and know this will be fine on all platforms

Thanks in advance
Fuzzy Received on Tue Jan 19 1999 - 21:41:09 CST