<div>
Sure. &nbsp;Bring the db down cleanly; copy the dbf's to your new target; mount the instance; alter the database by moving the datafiles to their new location; bounce the database. &nbsp;Do you need specifics or do you have access to the syntax?<br />
&nbsp;<br />

</div>


Sure.  Bring the db down cleanly; copy the dbf's to your new target; mount the instance; alter the database by moving the datafiles to their new location; bounce the database.  Do you need specifics or do you have access to the syntax?
 


<div>
I am preety new to oracl; can you provide me the procedure? <br />
<br />
Thanks,<br />

</div>


I am preety new to oracl; can you provide me the procedure?

Thanks,


<div>
<div class="content wysiwyg-content">
How to move oracle 10g database to other location/partiton in in windows 2003 server?<br />
<br />
we have dbf file in d: partition that has no enough space, is there any way to relocate this dbf file to other partiton?<br />
<br />
Please advise.<br />
<br />
Thanks,
</div>
</div>


How to move oracle 10g database to other location/partiton in in windows 2003 server?

we have dbf file in d: partition that has no enough space, is there any way to relocate this dbf file to other partiton?

Please advise.

Thanks,

How to move oracle 10g database to other location/partiton in in windows 2003 server?

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.