Re: Transferring Oracle database

On Nov 29, 6:35 pm, DA Morgan <damor..._at_psoug.org> wrote:
> 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.
> > MichalGiven 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.comand demos
> in Morgan's Library atwww.psoug.org.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -- Show quoted text -

I am not sure where the Oracle 5 came from but if the versions of Oracle are more recent and compatiable and if this is not a one-time thing then database links might be an option to push or pull table data between.

For non-compatiable SQLNET versions look at sqlldr formally called sqlloader.

HTH -- Mark D Powell -- Received on Thu Nov 30 2006 - 11:24:20 CST