This is a discussion on Moving tables/objects to a more recent version of Oracle within the Oracle Database forums, part of the Database Server Software category; --> 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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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@strauss-26 % exp login/pass@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@strauss-27 % So, what's the best way to go about getting the tablespace exported and moved onto a higher version? Bob |
| |||
| Connect directly on the server with an 815 client. "Time Vest Insurance" <reb@timevest.com> wrote in message news: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@strauss-26 % exp login/pass@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@strauss-27 % > > > So, what's the best way to go about getting the tablespace exported > and moved onto a higher version? > > Bob > |
| ||||
| "Time Vest Insurance" <reb@timevest.com> wrote in message news:l8z8yri6os9.fsf@timevest.com... > Thanks, I'll see if I can dig up 8.1.5 client files somewhere. > You don't need any other 8.1.5 client than the one already installed on your 8.1.5 server box. Just log on to that and run exp. Then ftp (binary) the dump to your target box, and you're away. Regards, Paul |