or netcat, should rsh be outlawed at your site. Mladen Gogala <mladen@xxxxxxxxxxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx 02/26/2004 12:18 PM Please respond to oracle-l To: oracle-l@xxxxxxxxxxxxx cc: Subject: Re: Moving db to linux 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@xxxxxxxx> 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@xxxxxxxxxxxxx > > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of > > Tanel P?der > > Sent: Thursday, February 26, 2004 1:39 AM > > To: oracle-l@xxxxxxxxxxxxx > > 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@xxxxxxx> > > > > To: oracle-l@xxxxxxxxxxxxx > > 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@xxxxxxxx> > > To: oracle-l@xxxxxxxxxxxxx > > 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@xxxxxxxx <mailto:anelson@xxxxxxxx > > <mailto:anelson@xxxxxxxx> > > > > > > > > > > > > ______________________________________________________________________________ > > 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 > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------