Riyaz

• Oct 8th, 2006

 

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

kartik

 Profile Answers by kartik Questions by kartik

• Oct 15th, 2006

 

Hi Riyaz,

but i m confused how can i do it?

plssssss. explain me.

venkat

• Feb 6th, 2007

 

Follow these steps
1) Install Oracle 8i Client
2) Export database from Oracle 8i Client PC
3) Import data into Oracle 8i Database.

Nidhi

• Feb 10th, 2007

 

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. "

ajay Gummadi

• Mar 2nd, 2007

 

By Applying Patches and Upgradation

Chiranjeevi Manne

• Mar 30th, 2007

 

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.

kodaliprakash

 Profile Answers by kodaliprakash 

• Jul 14th, 2007

 

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.

sanjayoracle

 Profile Answers by sanjayoracle 

• Apr 24th, 2008

 

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

narendra05

 Profile Answers by narendra05 

• Apr 23rd, 2010

 

I would suggest create a db link in Oracle 8 to Oracle 9i and run the CREATE TABLE AS SELECT FROM another database.

I would suggest you move to Oracle 10g /11g soon as Oracle support is already stopped to 9i and 8i release.

Narendra