Home » RDBMS Server » Server Utilities » Import/Export commands with different oracle versions
Import/Export commands with different oracle versions [message #73955] Tue, 10 August 2004 00:25 Go to next message
Sowdha
Messages: 1
Registered: August 2004
Junior Member
I have exported data from oracle 9.2 database.

How to import that data to oracle 8i database ?

 

Report message to a moderator

Re: Import/Export commands with different oracle versions [message #73956 is a reply to message #73955] Tue, 10 August 2004 03:35 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use the lower version to do export and same lower version to import (8i in your case).
else
if u want to use an 9i imp tool to import into 8i database, u need to install ( run catexp.sql of 9i) the export/import views of 9i into 8i database.

Report message to a moderator

Previous Topic: SQL*Loader : How to load based on the header-record
Next Topic: Question on SQL Loader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 09:00:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.