Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "can some one tell me what to do?" Watch "can some one tell me what to do?" New topic

can some one tell me what to do?

Mukunda Dhakate

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

Jaikiran Pai

Joined: Jul 20, 2005
Posts: 10441

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.

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:
subject: can some one tell me what to do?
It's not a secret anymore!