Re: Exports and inports

From: Valery Yourinsky <vsu_at_bill.mts.ru>
Date: Thu, 11 Jan 2001 09:39:18 +0300
Message-ID: <3A5D5516.2D703ED9@bill.mts.ru>

> I had a setup that had 7.3.4 throughout. Now we are trying to upgrade
> the databases in a phased manner and we have upgraded a part of it to
> 8.1.6 But I have a problem here. a script runs every month start and
> month end that will export tables from the now upgraded part(8.1.6 part)
> and the .dmp will have to be imported into a 7.3.4 database. Will this
> be a problem ? Has anyone encountered a situation like this. I do not
> want to go ahead and run the script without knowing about it as it would
> be a problem if the import failed.

   Hi,
   To do this task correctly you must run RDBMS/ADMIN/catexp7.sql script.

   ---
Rem NAME
Rem catexp7.sql - CATalog EXPort views for v7 SQL script Rem
Rem DESCRIPTION

Rem      Create v7 style export/import views against the v8 RDBMS
Rem      so that EXP/IMP v7 can be used to read out data in a v8 RDBMS

Rem
Rem NOTES
Rem
Rem This file is organized into 3 sections:

Rem	Section 1: Views needed by BOTH export and import
Rem	Section 2: Views required by import ONLY
Rem 	Section 3: Views required by export ONLY

   ---
   Then you will can use exp73 utility to export data from 8.1.6    and imp73 utility to import data into 7.3.4

Valery Yourinsky

-- 
Oracle8 Certified DBA

Received on Thu Jan 11 2001 - 00:39:18 CST