Monday 16 February 2015

How To Check Tablespace Name and corresponding Size ?

Answer> Execute the following statement.

select file_name,status,tablespace_name,bytes/1024/1024 from dba_data_files;

Cheers!!!


No comments:

Post a Comment