<div>
We now would like to delete all our datafiles and reclaim all our disk space.<br />
<br />
Sorry what I was trying to say is delete the extra datafiles added accept for the 4 original ones.<br />
<br />
Regards
</div>


We now would like to delete all our datafiles and reclaim all our disk space.

Sorry what I was trying to say is delete the extra datafiles added accept for the 4 original ones.

Regards

<div>
<div class="content wysiwyg-content">
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production<br />
With the Partitioning, OLAP and Oracle Data Mining options<br />
JServer Release 9.2.0.7.0 - Production<br />
<br />
System: Microsoft Windows Server 2003 Enterprise Edition<br />
--------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />--<br />
Hello how are you today? <br />
<br />
We have just implemented SAP in our environment. We were finding out that one of our tablespaces on our XI database kept on growing. To accommodate the growth we kept on adding datafiles. We went from 4 datafiles to 20 datafiles on drive G:\ORACLE\PXI\SAPDATA1 and 2 datafiles on N:\ORACLE\PXI\SAPDATA2. Our database is now at 150,000.00 Mb <br />
Just recently we were able to run some delete jobs supplied from SAP. We were able to get all our datafiles under 20% used. <br />
<br />
We now would like to delete all our datafiles and reclaim all our disk space.<br />
What is the best way of doing this??<br />
<br />
Can you please provide procedures on suggested ideas.<br />
<br />
Thank you for your time.<br />

</div>
</div>


Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

System: Microsoft Windows Server 2003 Enterprise Edition
----------------------------------------------------------
Hello how are you today? 

We have just implemented SAP in our environment. We were finding out that one of our tablespaces on our XI database kept on growing. To accommodate the growth we kept on adding datafiles. We went from 4 datafiles to 20 datafiles on drive G:\ORACLE\PXI\SAPDATA1 and 2 datafiles on N:\ORACLE\PXI\SAPDATA2. Our database is now at 150,000.00 Mb 
Just recently we were able to run some delete jobs supplied from SAP. We were able to get all our datafiles under 20% used. 

We now would like to delete all our datafiles and reclaim all our disk space.
What is the best way of doing this??

Can you please provide procedures on suggested ideas.

Thank you for your time.


Deleting Datafiles to Reclaim Space

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.