Limit size tablespace
Hi Oracle
Ours dba team want to limit size of a small file tablespace is 700GB.
I want to you confirm that MAXSIZE only applies to the datafile not the tablespace. And with small file tablespace, we can set maxsize 32G by block size 8k for a datafile not for tablespace. With big file tablespace ony one data file, we can set maxsize 700GB for datafile.