Home » RDBMS Server » Server Administration » imp/exp
imp/exp [message #61199] Mon, 05 April 2004 04:06 Go to next message
Jagdish.T
Messages: 3
Registered: October 2003
Junior Member
Hi,

I am unable to import some of the tables from oracle 9i database to oracle 8i. How that could happen?. Is it not compatible?. Please let me know the possibilities in this regard.

Thanks and Regards,

Jagdish

 

Report message to a moderator

Re: imp/exp [message #61201 is a reply to message #61199] Mon, 05 April 2004 04:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use 8i version of exp to export from 9i and same 8i version of imp utility to import into 8i.
idea is to use the lower version of exp/imp against a hihger version.
else
you have to install the expviews for 8i in the 9i database.

Report message to a moderator

Re: imp/exp [message #61202 is a reply to message #61199] Mon, 05 April 2004 04:33 Go to previous messageGo to next message
Anatol Ciolac
Messages: 113
Registered: December 2003
Senior Member
What are mean that you cannot import data? Are you get an error?

Report message to a moderator

Re: imp/exp [message #61205 is a reply to message #61199] Mon, 05 April 2004 05:33 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
You should be fine with Mahesh's advice here. Also have a look at here 9i-->8i

-Thiru

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic: ora-00205: error in identifying control files
Next Topic: Oracle universal installer error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:50:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.