I need to get the maximum size for an table size ,
I used the below command to create the tablespace
Create tablespace sam datafile '+Vol01' size 20G autoextend on next 1G maxsize 31G;.
Alter tablespace sam add datafile '+Vol01' size 20G autoextend on next 1G maxsize 31G;.
We have RAC environment , two instances of the database running.
I need the below clarification in regard to tablespace
1. what is the difference between Tablespace and datafiles ?
2. Once the initial size is full , to which data file does oracle autoextend to 1GB
3. How to get the Total size , USED size and Free Size ofthe tablespace and datafiles .
I tried the below query , not sure about the output
Select bytes , MAxBytes from DBA_DATA_FILES . Is it correct.