Re: Which platform has the largest possible data block size?

Fuzzy,

For a generic solution obtain the db_block_size using

select value block_size_in_bytes
from v$parameter
where name like 'db_block_size'

And then use this value in your create table storage clause...

Chris

Fuzzy wrote in message
<36a54ed9.20265337_at_newshost.interact.net.au>...
>Hi all,
>.....
>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.
>
Received on Wed Jan 20 1999 - 01:58:14 CST