<div>
Im not sure I follow...what would the command:<br />
ALTER TABLESPACE users<br />
&nbsp; &nbsp; ADD DATAFILE '/u02/oracle/rbdb1/users03<wbr />.dbf' SIZE 10M reuse existing<br />
do?
</div>


Im not sure I follow...what would the command:
ALTER TABLESPACE users
    ADD DATAFILE '/u02/oracle/rbdb1/users03.dbf' SIZE 10M reuse existing
do?

<div>
Here is a site that can help you with an example and explanation. <br />
<br />
<a href="http://www.psoug.org/reference/datafiles.html" rel="ugc">http://www.psoug.org/reference/datafiles.html</a>
</div>


Here is a site that can help you with an example and explanation.

http://www.psoug.org/reference/datafiles.html [http://www.psoug.org/reference/datafiles.html]

<div>
I see...so basically I would have to first drop that file then add it using the reuse command? &nbsp;Thanks for your help again.
</div>


I see...so basically I would have to first drop that file then add it using the reuse command?  Thanks for your help again.

<div>
<div class="content wysiwyg-content">
I am running oracle 10g on windows server 2003. &nbsp;When you are adding a new datafile, what does the command &quot;reuse existing&quot; do? &nbsp;
</div>
</div>


I am running oracle 10g on windows server 2003.  When you are adding a new datafile, what does the command "reuse existing" do?  

reuse existing command when adding a datafile

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.