This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes can some one tell me what to do? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "can some one tell me what to do?" Watch "can some one tell me what to do?" New topic
Author

can some one tell me what to do?

Mukunda Dhakate
Greenhorn

Joined: Jan 27, 2006
Posts: 5
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

Joined: Sep 06, 2003
Posts: 259
I would suggest you to contact Oracle Support center


http://www.skillassert.com


Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 9924
    
158

Backup the database


[My Blog] [JavaRanch Journal]
Purushoth Thambu
Ranch Hand

Joined: May 24, 2003
Posts: 425
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 ]
 
jQuery in Action, 2nd edition
 
subject: can some one tell me what to do?
 
Similar Threads
Make DSN on Windows for Oracle TimesTen
Connecting To Oracle
Installing the Data base, Application server, IDE together
oracle home in win 2000
Installing the Data base, Application server, IDE together