Oracle [message #8078] |
Fri, 25 July 2003 00:34 |
Harjeet Gill
Messages: 1 Registered: July 2003
|
Junior Member |
|
|
I just upgraded my Oracle 7.3 to 8i , I dont know how to make 8i to see the old data . I am using it for my home but has lot of data . please help me I am new in oracle. But has a lot of data need to update. Thanks
|
|
|
Re: Oracle [message #8090 is a reply to message #8078] |
Fri, 25 July 2003 09:48 |
Thomas G
Messages: 58 Registered: April 2003
|
Member |
|
|
The normal procedure would be
1. Backup everything. (Unless you want to learn the hard way ;-) )
2. Export the data from the Database
(exp user/password@database from the command line, then answer the questions)
3. Install new Oracle Version
4. create an empty database with enought space avaiable
5. Import the data
(imp user/password@database)
|
|
|
Re: Oracle [message #8132 is a reply to message #8078] |
Tue, 29 July 2003 08:10 |
Raj
Messages: 411 Registered: November 1998
|
Senior Member |
|
|
Check your tools in oracle 8i data base configuration
oracle data migration assistant
|
|
|