If we have set auto extend on in any tablespace and did not define the max size
What is the maximum size tablespace can grow?
Can it be unlimited?
Please share your thoughts on it.
Thanks in advance.
No Comments Posted for this Article.
The size of table TST03 grows
The size of table TST03 and thus the corresponding tablespace increases continually. Unfavorable block length for table TST03, especially for oracle as block length a) Explanation of the problem ...
Query About Single Table-space.
Hello Experts A single tablespace supports maximum of 65,536 datafiles. If i created 10 tablespaces then 10X65,536. Is it right. Another thing is upt to how much size of datafile is...
Oracle Locally Managed Table Spaces
Default table spaces from 10g which manage the extents locally instead of dictionary management.. It collase the space that is left in all the extents before allocating an extent. It reduces...