SQL> select tablespace_name,file_name,(bytes/1024/1024) from dba_data_files where tablespace_name='USERS'
TABLESPACE FILE_NAME (BYTES/1024/1024)
-------------- -----------------------------------------------------------------------------------------------------------------
USERS +DATA/kkprod/datafile/users.267.962995627 25600
USERS +DATA/kkprod/datafile/users.269.963077837 20480
Happy Learning....
No comments:
Post a Comment