ODI - database - datafile - check used and allowed max file size

Run the following commands to get the tablesapce used size, allocated max size:

For all Tablespace:

Select FILE_NAME, FILE_ID, TABLESPACE_NAME, BYTES/1024/1024/1024 size_gb, maxbytes/1024/1024/1024 max_gb, STATUS, AUTOEXTENSIBLE, ONLINE_STATUS from dba_data_files

For speecific tablespace:

Select FILE_NAME, FILE_ID, TABLESPACE_NAME, BYTES/1024/1024/1024 size_gb, maxbytes/1024/1024/1024 max_gb, STATUS, AUTOEXTENSIBLE, ONLINE_STATUS from dba_data_files where  tablespace_name in ('undo_8')