Home » SQL & PL/SQL » SQL & PL/SQL » Oracle
Oracle [message #8078] Fri, 25 July 2003 00:34 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
Raj
Messages: 411
Registered: November 1998
Senior Member
Check your tools in oracle 8i data base configuration
oracle data migration assistant
Previous Topic: combining data ( cross posting)
Next Topic: complex query!help me!!
Goto Forum:
  


Current Time: Fri Apr 26 12:45:24 CDT 2024