Home » RDBMS Server » Server Utilities » Importing .dmp file made in Oracle8i to Oracle8
Importing .dmp file made in Oracle8i to Oracle8 [message #72297] Fri, 02 May 2003 15:09 Go to next message
Rajan
Messages: 7
Registered: February 2001
Junior Member
Please if anybody could tell how to import a .dmp file made in Oracle 8.1.6 to Oracle 8.0.5

Regards
Rajan
Re: Importing .dmp file made in Oracle8i to Oracle8 [message #72301 is a reply to message #72297] Mon, 05 May 2003 04:38 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
u can use copy cmd to copy some specific obj.

If u need the whole database, run catexp7.sql. Use exp ( release 8.05, must be in 8.05 environnement ) to extract DATA ( exp usr/passwd@DB816 ).

Run import.
Previous Topic: Manipulating a CSV file load in sqlldr
Next Topic: ORA -26095
Goto Forum:
  


Current Time: Tue Dec 24 06:20:05 CST 2024