Re: Database size after Duplicat

Posted by big on Jul 13, 2021; 6:45pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Database-size-after-Duplicat-tp9962p9969.html

Hi,
Yes thank you.

===============on DEV========================================
SQL> select sum (bytes/(1024*1024*1024)) from v$datafile;
SUM(BYTES/(1024*1024*1024))
---------------------------
                 508.529297
=========================On PROD=================================
SQL> select sum (bytes/1024*1024*1024)) from v$datafile;
SUM(BYTES/(1024*1024*1024))
---------------------------
                 509.592773
Then they are nearly the same if not mistaken. So on DEV we have some supplementary expired dbf files.

How can I identify and delete them without risk for our DB?

Thanks.