aspose file tools*
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
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: 10263
    
168

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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: can some one tell me what to do?