<div>
<div class="content wysiwyg-content">
I export a backup of my database using the following. How can I overwrite the existing database from a dump file.<br />
<br />
set oracle_sid=scrp<br />
exp scrapware/recycle grants=yes owner=scrapware <br />
<br />
file=H:\scrp-dump\expSCRp%<wbr />date:~4,2%<wbr />%date:~7,2<wbr />%%date:~-4<wbr />%%time:~0,<wbr />2%%time:~3<wbr />,2%%<br />
<br />
time:~6,2%%time:~-2%.dmp
</div>
</div>


I export a backup of my database using the following. How can I overwrite the existing database from a dump file.

set oracle_sid=scrp
exp scrapware/recycle grants=yes owner=scrapware 

file=H:\scrp-dump\expSCRp%date:~4,2%%date:~7,2%%date:~-4%%time:~0,2%%time:~3,2%%

time:~6,2%%time:~-2%.dmp

How to Import a complete Database in Oracle 9i

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.