<div>
Do you have a backup. Maybe even a cold backup? Restore the backup on another machine and then use it to transfer the data back. 
</div>


Do you have a backup. Maybe even a cold backup? Restore the backup on another machine and then use it to transfer the data back.

<div>
<div class="content wysiwyg-content">
my tablespace is corrupted it contains static tables and the database in noarchive log mode.<br />
Is there any way to &nbsp;restore the tablespace with out losing the data in other tablespaces..<br />

</div>
</div>


my tablespace is corrupted it contains static tables and the database in noarchive log mode.
Is there any way to  restore the tablespace with out losing the data in other tablespaces..


restore tablespaces

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.