Integer value for file size
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 23 Oct 2019 15:31:04 -0400
Message-ID: <CALcG2DK44-PEhzmS+j7atbtJdJFfL3OJ-2BtP6Rg6GOPpTjnzQ_at_mail.gmail.com>
I tried the following:
QL> alter tablespace dovetail add datafile '+DATA' size 31.9G;
Date: Wed, 23 Oct 2019 15:31:04 -0400
Message-ID: <CALcG2DK44-PEhzmS+j7atbtJdJFfL3OJ-2BtP6Rg6GOPpTjnzQ_at_mail.gmail.com>
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"
*Cause:
*Action:
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?
Regards
-- Kindest regards, Mladen Gogala -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 23 2019 - 21:31:04 CEST