Toad World® Forums

Bigfile Tablespace Datafile resize: ORA-00740

When resizing a datafile belonging to a bigfile tablespace, Toad generates the SQL below. The autoextend clause fails with ORA-00740. The resize is successful. I did not investigate this. I am using Oracle 12.2.0.1 EE on Linux.

ALTER DATABASE
DATAFILE '/u02/oradata/ltarch/lttempe01.dbf'
RESIZE 60000M;
ALTER DATABASE
DATAFILE '/u02/oradata/ltarch/lttempe01.dbf'
AUTOEXTEND ON
NEXT 100M
MAXSIZE 32T;

what is the blocksize for that tablespace?

The block size is 8K.

I can reproduce it on 19c.
Oracle docs say 32T is the max size with 8k, so I'm not sure what the problem is.
It worked if I put "UNLIMITED" as max size in the alter tablespace window.