Unix Technical Forum

Moving tables/objects to a more recent version of Oracle

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 ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-22-2008, 04:58 PM
Time Vest Insurance
 
Posts: n/a
Default Moving tables/objects to a more recent version of Oracle



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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-22-2008, 05:37 PM
Telemachus
 
Posts: n/a
Default Re: Moving tables/objects to a more recent version of Oracle

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
>



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-22-2008, 05:38 PM
Paul Brewer
 
Posts: n/a
Default Re: Moving tables/objects to a more recent version of Oracle

"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



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:33 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com