restore tablespaces

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..
nobleitAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
What objects are corrupt? You can try to export the tables.  Rebuild the database then import.
0
 
anand_2000vCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.