This content has been marked as final. Show 3 replies
Potentailly you could re-install the Oracle software onto the PC and then as long as the database files are fine just start the database. Once available you would then have several options for migrating the data.1 person found this helpful
Since you have a backup then you ought to be able to use rman to restore the backup (to a new server) and access the database from there extracting just the tablespace of interest via export, database links, or transportable tablespaces.
Speaking of exports if you made one of your PC database then depending on its age, etc... you might just be able to use it to get the objects and data of interest.
You do not mention the platform the remaining database is on. This can be an important factor for what options are practical.
HTH -- Mark D Powell --
Reinstall the software
1) How to create a windows service? On caommand prompt
oradim -new -sid <sid name> -intpwd <sys password>
If this helps and you can start your old database than take an export of all the objects in that tablespace and import in another database.
Restore the full database using RMAN somwwhere else and than take export of all the objects in that tablespace and import into another database.
Edited by: TSharma on Jan 17, 2013 11:34 AM
Thanks guys for your patience and attention. I simply recreated the windows service. Fortunatelly, my DB was not corrupted. Now i can access it.