List All Datafile Of Undo Tablespace

List All Datafile Of Undo Tablespace SELECT tablespace_name,file_name,file_id,autoextensible,bytes / 1048576 Mbytes,maxbytes / 1048576 maxMbytesFROM dba_data_filesWHERE tablespace_name LIKE ‘%UNDO%’OR tablespace_name LIKE ‘%RBS%’ORDER BY tablespace_name,file_name; Read More … Read more