ABHI@xxxxx> select tablespace_name, file_name, bytes/1024/1024, maxbytes/1024/1024 from dba_temp_files where tablespace_name='UC_TEMP';

TABLESPACE_NAME                FILE_NAME                                          BYTES/1024/1024 MAXBYTES/1024/1024
------------------------------ -------------------------------------------------- --------------- ------------------
UC_TEMP                        /oradata03/xxxxx/data/uc_temp.dbf                          2000.06            4096.00


xxxxx*------Environment