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 -> Moving tables/objects to a more recent version of Oracle

Moving tables/objects to a more recent version of Oracle

From: Time Vest Insurance <reb_at_timevest.com>
Date: 01 Jul 2003 00:14:18 +0000
Message-ID: <l8zisqnyug5.fsf@timevest.com>

I have 3 versions of Oracle running--- 8.1.5, 8.1.7, and 9.x

I have a tablespace on 8.1.5 that I want to move to either of the other two Servers.

When I run exp, I get this result:

bbrown_at_strauss-26 % exp login/pass_at_ORA815

Export: Release 8.1.7.4.0 - Production on Mon Jun 30 19:32:18 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
EXP-00037: Export views not compatible with database version EXP-00000: Export terminated unsuccessfully bbrown_at_strauss-27 %

So, what's the best way to go about getting the tablespace exported and moved onto a higher version?

Bob Received on Mon Jun 30 2003 - 19:14:18 CDT

Original text of this message

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