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.

It also worked when I changed to UNLIMITED. Could be have to use 32T - 1 (start counting at 0)?

The highest value that I could get it to work with was 35184372064256.
This is 24Kb lower than 32T. I don't know the significance of this 24K. It may vary by block size. Mine is also 8K.

Interesting. Thank you for the info