Unanswered: What is the maximum size can a tablespace have?
Am new to Oracle. Would like to hear advise on what is the maximum size allow for a tablespace in Oracle. Also, will there be problems (eg performance, data corruption, etc) if a tablespace is too big?
I have a tablespace that is currently 5GB in used, is it recommended to increase the tablespace 1GB by 1GB or increase it by 2GB in 1 go?