Script will not work. I also forgot the node name to instruct rsh
(or netcat, as Jared pointed out) where to go. Anyway, with few
minor details, the recipy is in there.
On 02/26/2004 04:14:48 PM, mkb wrote:
> Ahh...that's it, and just to make sure, run as root
> right ;)
>
> --- Mladen Gogala <mladen_at_wangtrading.com> wrote:
> > What you need is a magic wand. On Solaris, it's
> > called "rsh".
> > The spell goes like this:
> > System A, prior to the operation:
> > mknod expdat.dmp p
> > System B, prior to the operation:
> > mknod exp_remote.dmp p
> >
> > System A, engaging the enemy:
> > exp parfile=myexp.par 2>/dev/null &
> > dd if=expdat.dmp|rsh dd of=exp_remote.dmp
> >
> > imp parfile=myimp.par file=exp_remote.dmp
> > log=/vmunix
> >
> >
> >
> >
> > On 02/26/2004 03:01:13 PM, mkb wrote:
> > > As an aisde, can you not exp to a pipe on one
> > machine
> > > and exp from the pipe on the other machine.
> > >
> > > I remember doing something like this using a
> > > combination of pipes, rsh and dd from Sun-to-Sun.
> > >
> > > Any ideas out there?
> > >
> > > mohammed
> > >
> > > --- "Nelson, Allan" <anelson_at_midf.com> wrote:
> > > > Thanks for the response. There was a key fact
> > > > missing from what I told you, sorry. The HP
> > > > database is in a computer room connected by a
> > pair
> > > > of T1's to our computer room. With an aggregate
> > > > throughput orf 3.08 Mb / sec. I had thought
> > that
> > > > any sort of sql copy or ctas type solution would
> > be
> > > > out because of the bandwidth requirements.
> > > >
> > > > Sorry again,
> > > > Allan
> > > >
> > > > -----Original Message-----
> > > > From: oracle-l-bounce_at_freelists.org
> > > > [mailto:oracle-l-bounce_at_freelists.org] On Behalf
> > Of
> > > > Tanel P?der
> > > > Sent: Thursday, February 26, 2004 1:39 AM
> > > > To: oracle-l_at_freelists.org
> > > > Subject: Re: Moving db to linux
> > > >
> > > >
> > > > Sorry, I didn't see the HP-UX part in beginning
> > of
> > > > your mail.
> > > > Yep, you have to go with exp-imp for changing
> > > > platforms.
> > > >
> > > > I'd go with exp-imp with rows=n indexes=n
> > > > constraints=n and transfer all data over dblink.
> > > > After which I'd run modified create index
> > statements
> > > > on tables followed by imp constraints=y.
> > > >
> > > > Here's a simple query for generating insert
> > > > commands over database link (you might want to
> > > > remove parallel hint and use several serial
> > inserts
> > > > instead):
> > > >
> > > >
> > > > set linesize 300
> > > >
> > > > set pagesize 0
> > > >
> > > > set feedback off
> > > >
> > > > set trimspool on
> > > >
> > > >
> > > >
> > > > spool /tmp/apps_insert.sql
> > > >
> > > >
> > > >
> > > > prompt alter session enable parallel dml;;
> > > >
> > > >
> > > >
> > > > select 'insert /*+ APPEND PARALLEL(' ||
> > table_name
> > > > || ',4) NOLOGGING */ into '
> > > >
> > > > || owner || '.' || table_name
> > > >
> > > > || ' select * from ' || owner || '.' ||
> > > > table_name || '@dblink;'
> > > >
> > > > from dba_tables
> > > >
> > > > where owner in ('AP', 'APPLSYS', 'APPS', 'AR',
> > > > 'GL', 'JE')
> > > >
> > > > order by owner;
> > > >
> > > >
> > > >
> > > > spool off
> > > >
> > > > exit
> > > >
> > > >
> > > > Tanel.
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: Tanel P?der
> > <mailto:tanel.poder.003_at_mail.ee>
> > > >
> > > > To: oracle-l_at_freelists.org
> > > > Sent: Thursday, February 26, 2004 9:28 AM
> > > > Subject: Re: Moving db to linux
> > > >
> > > > Hi
> > > >
> > > > Who told you you have to use exp-imp for that?
> > > > Since the platform remains the same, you can
> > use
> > > > regular migration path to go from 8i to 9i.
> > > >
> > > > Tanel.
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: Nelson, Allan <mailto:anelson_at_midf.com>
> >
> > > > To: oracle-l_at_freelists.org
> > > > Sent: Wednesday, February 25, 2004 7:22 PM
> > > > Subject: Moving db to linux
> > > >
> > > >
> > > > Im, going to be moving a 220 GB 8.1.7.4
> > database
> > > > from HP-UX to Red Hat AS 3.0 running 9.2.0.4.0.
> > I'm
> > > > told that we have to use export/import to get
> > that
> > > > job done. I plan to work through pipes and use
> > > > split to keep the file sizes to 2 GB or less to
> > > > aviod large file issues between the platforms.
> > Does
> > > > anyone know of other issues that may trip me up?
> >
> > > >
> > > > Thanks In Advance
> > > >
> > > > Allan L. Nelson
> > > > Oracle DBA
> > > > M-I L.L.C.
> > > > (832) 295-2238 office
> > > > (832) 351-4180 fax
> > > > anelson_at_midf.com <mailto:anelson_at_midf.com
> > > > <mailto:anelson_at_midf.com> >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> ______________________________________________________________________________
> > > > This email is intended solely for the person
> > or
> > > > entity to which it is addressed and may contain
> > > > confidential and/or privileged information.
> > Copying,
> > > > forwarding or distributing this message by
> > persons
> > > > or entities other than the addressee is
> > prohibited.
> > > > If you have received this email in error, please
> > > > contact the sender immediately and delete the
> > > > material from any computer. This email may have
> > been
> > > > monitored for policy compliance. [021216]
> > > >
> > > >
> > > >
> > >
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Get better spam protection with Yahoo! Mail.
> > > http://antispam.yahoo.com/tools
> > >
> >
> ----------------------------------------------------------------
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > >
> >
> ----------------------------------------------------------------
> >
> === message truncated ===
>
>
> __________________________________
> Do you Yahoo!?
> Get better spam protection with Yahoo! Mail.
> http://antispam.yahoo.com/tools
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Feb 26 2004 - 15:23:29 CST
