OraFAQ Forum: Windows » Help backup on database

Home » Infrastructure » Windows » Help backup on database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help backup on database [message #100737]

Sun, 13 July 2003 14:50

Mihai Cristofor
Messages: 8
Registered: July 2003

Junior Member

Please help. I'm new to oracle. where i'm working I have oracle 9i release 2 and a rather big database with big tables, stored procedures and so on... The problem is i must reinstall the server (windows xp) and i have to save somehow the database. I tried to simply copy the files but obviously it didn't work. Is there any way to export it and then, after i reinstall my system to import it???? Thank you very much...

Report message to a moderator

Re: Help backup on database [message #100738 is a reply to message #100737]

Mon, 14 July 2003 10:14

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

export the database (full) and secure it.
do an re-instaall OS
reinstall oracle
recreate the seed database.
recreate the tablespaces with the same names as before
import

look into oracle utitilies manual for help on export / import

Report message to a moderator

Re: Help backup on database [message #100739 is a reply to message #100738]

Mon, 14 July 2003 10:28

Mihai Cristofor
Messages: 8
Registered: July 2003

Junior Member

Thank you very much for information. I have just one more question:
Where can I find Oracle utilities manual and eventually a PL/SQL manual.

Thank you again.

Report message to a moderator