Backup and Recovery - How can I Export 9i data in 8 ? I mean when I Export from 9i and Import in 8, I face errors. what so

GeekInterview.com > Interview Questions > Oracle > Backup and Recovery

Go To First | Previous Question | Next Question

Backup and Recovery | Question 22 of 42

How can I Export 9i data in 8 ? I mean when I Export from 9i and Import in 8, I face errors. what sould I do and my pc is not in Network.

Total Answers and Comments: 8

Last Update: April 24, 2008 Asked by: kartik

Sponsored Links

Best Rated Answer

—

Submitted by: kodaliprakash

Oracle does not support backward compatibility for exp/imp, so if you export in 9i you have to import in higher version than 9i only.

Above answer was rated as good by the following members:
makecenter

October 08, 2006 01:39:26

Riyaz

RE: How can I Export 9i data in 8 ? I mean when I Expo...

execute catexp.sql of 8 in oracle 9i then take export and then import in 8 database.

Is this answer useful? Yes | No

October 15, 2006 05:00:24

kartik

Member Since: November 2005 Contribution: 3

RE: How can I Export 9i data in 8 ? I mean when I Expo...

Hi Riyaz

but i m confused how can i do it?

plssssss. explain me.

Is this answer useful? Yes | No

February 06, 2007 13:04:42

venkat

RE: How can I Export 9i data in 8 ? I mean when I Expo...

Follow these steps

1) Install Oracle 8i Client

2) Export database from Oracle 8i Client PC

3) Import data into Oracle 8i Database.

Is this answer useful? Yes | No

February 10, 2007 05:59:53

Nidhi

RE: How can I Export 9i data in 8 ? I mean when I Expo...

How can I Export 9i data in 8 ? I mean when I Expo... -------------------------------------------------------------------------------- Follow these steps1) Install Oracle 8i Client 2) Export database from Oracle 8i Client PC 3) Import data into 'Oracle 9i' Database.

Is this answer useful? Yes | No

March 02, 2007 08:14:52

ajay Gummadi

RE: How can I Export 9i data in 8 ? I mean when I Expo...

By Applying Patches and Upgradation

Is this answer useful? Yes | No

March 30, 2007 18:13:36

Chiranjeevi Manne

RE: How can I Export 9i data in 8 ? I mean when I Expo...

The Best possible method is using Oracle 81 EXP utility take the export and import it into 8i database. For this either one should install Oracle 8i and take export or Install 8i client and take the export using oracle 8i client.

Is this answer useful? Yes | No

July 14, 2007 00:21:53

kodaliprakash

Member Since: July 2007 Contribution: 10

RE: How can I Export 9i data in 8 ? I mean when I Expo...

Oracle does not support backward compatibility for exp/imp so if you export in 9i you have to import in higher version than 9i only.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

April 24, 2008 22:29:04

sanjayoracle

Member Since: April 2008 Contribution: 4

RE: How can I Export 9i data in 8 ? I mean when I Export from 9i and Import in 8, I face errors. what sould I do and my pc is not in Network.

we can do it. but first we have to confirm that parameter NLS_LANG is same in both database. otherwise in IMP process oracle will give error

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank