Re: exp sun & imp win

"Richard Foote" <richard.foote_at_bigpond.com> writes:

>>> "Sergio" <smeligr_at_libero.it> wrote in message
>>> news:bat12t$3464c$1_at_ID-186754.news.dfncis.de...
>>> > Is possible export to sun solaris and import to Windows?
>>> >
>>>
>>> Hi Sergio,
>>>
>>> Yes.
>>>
>>> Not sure what else to say :)

On Sun:

/usr/sbin/mknod /tmp/exp_imp_pipe p

... this will creata a pipe -> man mknod

In one shell start (maybe try "exp help=y"):

exp \"/ as sysdba\" file=/tmp/exp_imp_pipe log=your_export..log owner=your_user

... this will tigger the export and write the output to the pipe just created.

In another shell type (maybe try "imp help=y"):

imp \"sys_at_win.db.com as sysdba\" file=/tmp/exp_imp_pipe log=your_import.log fromuser=sun_user touser=win_user ignore=y commit=y

... this will trigger an import on the windows machine via net8.

On Windows set up the database and the tablespaces.

        regards & hth

                Tom