This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

can some one tell me what to do?

 
Mukunda Dhakate
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i was having Oracle installed on my system.
but due to some problem i have to format the PC.
i have installed oracle on separate drive.
and i have prepared lots of table on that.
now how can i use those tables again after re-installing the OS.
how can i retrive the old data.
please help.
 
karthikeyan Chockalingam
Ranch Hand
Posts: 259
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would suggest you to contact Oracle Support center
 
Jaikiran Pai
Marshal
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
 
Purushoth Thambu
Ranch Hand
Posts: 425
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
All you need to do is backup the schema if you have stored the tables in one user id.


This link should be more helpful. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm


After you reinstall the Oracle create same user you have now currently and then use "imp" to import the tables.

If you have tools like TOAD then this will be much easier. You can also consider exporting individual tables in text/xml format but this will be time consuming.
[ October 10, 2006: Message edited by: Purushothaman Thambu ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic