Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to export from a higher Oracle version and import into a lower Oracle version

Re: How to export from a higher Oracle version and import into a lower Oracle version

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Tue, 27 Jul 2004 19:06:40 +0200
Message-ID: <5q2dg05gop0uqhi3papjo0jsbfsqd6jivt@4ax.com> 





On Tue, 27 Jul 2004 16:16:33 +0200, "dead"
<OVOIZBACI-vlasic_at_vodatel.net> wrote:



>How to export from a higher Oracle version (10) and import into a lower

>Oracle version (9)

>




Use the lower version export against the higher version database.
Be sure to have created the v9 export views in the 10g database.
usually they are called $ORACLE_HOME/rdbms/admin/catexp<version>.sql
They must be run using SYS as SYSDBA



--
Sybrand Bakker, Senior Oracle DBA


Received on Tue Jul 27 2004 - 12:06:40 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US