Probably not, since database files are tracked by blocks in the data file and
your decimal number may not resolve to a byte size that ends on a block
boundary based on your block size.
Fundamental table file$ tracks blocks not bytes and the views over the top have
the multiplication in them blocksize * blocks to derive bytes.
1024*1024*1024 = 1,073,741,824
1,073,741,824 * .9=966,367,641.6 < decimal byte…..
Even if rounded
Down: 966,367,641 odd number won’t be evenly divisible by 2 to the power block
Up: 966,367,642 is also not divisible evenly by Oracle block sizes.
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Mladen Gogala
Sent: Wednesday, October 23, 2019 12:31 PM
Subject: Integer value for file size
I tried the following:
QL> alter tablespace dovetail add datafile '+DATA' size 31.9G;
Error starting at line : 1 in command -
alter tablespace dovetail add datafile '+DATA' size 31.9G
Error report -
ORA-02017: integer value required
02017. 00000 - "integer value required"
I know that I can do 32767M instead of 31.9G but it's too many characters to
type. Is there a possibility that Oracle Corp. will cater to my laziness and
allow me to type 31.9G?