RE: Creating and Oracle 7 DB from an Oracle 8 DB

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Wed, 06 Jun 2001 06:47:45 -0700
Message-ID: <F001.0031DF83.20010606063137@fatcity.com>

<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_at_fatcity.com   [mailto:root_at_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_at_ram">mailto:tim.allen_at_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 ]
    Received on Wed Jun 06 2001 - 08:47:45 CDT