Re: Transferring Oracle database

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 UX),
> to Oracle based on Windows 2000 Server...
> I wonder, if there is any possibility (or "cheap" tool) to copy settings and
> data between different systems... I know, I can export data from old
> machine, and import inside new one - I can do it... But unfortuantely I'm
> not very familiar with such migrations, so all helpful links or infos will
> be appreciated..
> Normally, I'm database user, little bit of Oracle administrations (IT
> specialist, but not database admins specialist)
>
> Many thanks in avance.
> Michal

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.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org