Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Transferring Oracle database
Michal AKA Miki wrote:
> Uzytkownik "DA Morgan" <damorgan_at_psoug.org> napisal w wiadomosci
> news:1164843348.937245_at_bubbleator.drizzle.com...
>> Michal AKA Miki wrote: >>> Hi... >>> >>> Maybe somebody will help me with one thing.. >>> >>> I've just faced new task - copying data from Oracle based on Unix (HP
>>> to Oracle based on Windows 2000 Server... >>> I wonder, if there is any possibility (or "cheap" tool) to copy settings
>>> data between different systems... I know, I can export data from old >>> machine, and import inside new one - I can do it... But unfortuantely
>>> not very familiar with such migrations, so all helpful links or infos
>>> be appreciated..
>> Given that you are working with Oracle version 5 it is not possible. <g> >> >> On the other hand if you have 8i or above you could use Export/Import >> 9i or above you could use Transportable Tablespaces >> 10g or above you could use DataPump or External Tables >> >> All of these are free ... hope that is cheap enough. >> Documentation can be found at: http://tahiti.oracle.com and demos >> in Morgan's Library at www.psoug.org.
The differences between 8.1.6 and anything currently supported are monumental. I would recommend setting up the 10g database as a new install and then moving the data but none of the configuration.
If you are not familiar with UNDO, ASSM, the recyclebin, and a large number of other features, including the disappearance of SVRMGRL do your homework first.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Dec 01 2006 - 10:28:45 CST