• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

can some one tell me what to do?

 
Mukunda Dhakate
Greenhorn
Posts: 5
  • 0
  • 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
  • 0
  • 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
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Backup the database
 
Purushoth Thambu
Ranch Hand
Posts: 425
  • 0
  • 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 ]
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic