From mark@cool-tools.co.uk Wed, 06 Jun 2001 06:47:45 -0700
From: "Mark Leith" <mark@cool-tools.co.uk>
Date: Wed, 06 Jun 2001 06:47:45 -0700
Subject: RE: Creating and Oracle 7 DB from an Oracle 8 DB
Message-ID: <F001.0031DF83.20010606063137@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



<FONT face=Arial color=#0000ff 
size=2>Tim,
<FONT face=Arial color=#0000ff 
size=2> 
AFAIK 
you can run the version 7 export utility against the version 8 database, but you 
have to run the catexp7.sql script on the 8 database?
<FONT face=Arial color=#0000ff 
size=2> 
<FONT face=Arial color=#0000ff 
size=2>Something like that.. have never done it :)
<FONT face=Arial color=#0000ff 
size=2>Regards
<FONT face=Arial color=#0000ff 
size=2> 
<SPAN 
class=805312113-06062001>Mark<SPAN 
class=805312113-06062001>

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: root@fatcity.com 
  [mailto:root@fatcity.com]On Behalf Of Tim AllenSent: 
  Wednesday, June 06, 2001 10:06To: Multiple recipients of list 
  ORACLE-LSubject: Creating and Oracle 7 DB from an Oracle 8 
  DB
  
  <FONT face=Arial 
  size=2>Hi,
  <FONT face=Arial 
  size=2> 
  Its a long and 
  boring story but I have an Oracle 8 database and I need to create 
  an Oracle 7 database from it to support one of our applications. The 
  schema of the Oracle 8 db does not have any oo features and is, in theory, it 
  functionally compatable with an Oracle 7 db. But I understand that there are 
  issues with using export from oracle 8 and import to oracle 7, I.e it is 
  incompatable. 
  <FONT face=Arial 
  size=2> 
  Has anyone had any 
  experience in doing this or any suggestions on ways of doing 
  it?
  <FONT face=Arial 
  size=2> 
   And by the 
  way the data in tables needs to be copied from 8 to 7 
also.
  <FONT face=Arial 
  size=2> 
  <FONT face=Arial 
  size=2>Cheers
   
  Tim Allen<FONT 
  face=Arial color=#008080 
  size=2>DesignerRam<FONT face="Times New Roman" 
  color=#008080 size=4>e<FONT 
  face=Arial color=#008080 size=2>sys (Professional Services) 
  Ltd<FONT face=Wingdings color=#000080 
  size=2>(<FONT face="Times New Roman" 
  size=2>     
    Phone: 01788 822133 <FONT 
  face=Wingdings color=#008000 size=2>.       
  Fax : 01788 822144 <FONT 
  face=Wingdings color=#ff0000 
  size=2>+         <FONT 
  face=Arial size=2>Address : Eldon Way, Motorway Ind. Estate, Crick, Northants, 
  NN6 7SL <FONT face=Wingdings color=#0000ff 
  size=2>*         <FONT face=Arial 
  size=2>E-mail  : [<A 
  target=_blank 
  href="mailto:tim.allen@ram">mailto:tim.allen@ram<FONT 
  face="Times New Roman" color=#0000ff size=4>e<FONT face=Arial 
  color=#0000ff size=2>sys.com] 
  [ The views and opinions 
  expressed in the email are the sender's own   ][ and do not 
  necessarily represent the views and opinions of 
  Ram<FONT face="Times New Roman" color=#000000 
  size=4>esys LTD ]