From oracle-l-bounce@freelists.org Thu Feb 26 14:16:06 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1QKG6U04397 for ; Thu, 26 Feb 2004 14:16:06 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1QKG6o04392 for ; Thu, 26 Feb 2004 14:16:06 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 43FFF39631E; Thu, 26 Feb 2004 15:17:24 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 26 Feb 2004 15:16:19 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from smtp.wangtrading.com (smtp.wangtrading.com [167.206.68.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6BBF6395A7D for ; Thu, 26 Feb 2004 15:16:06 -0500 (EST) Received: from mladen.wangtrading.com (Not Verified[192.168.3.47]) by smtp.wangtrading.com with NetIQ MailMarshal (v5.5.5.8) id ; Thu, 26 Feb 2004 15:17:49 -0500 Received: from mladen (localhost.localdomain [127.0.0.1]) by mladen.wangtrading.com (8.12.8/8.12.8) with ESMTP id i1QKIwfn015315 for ; Thu, 26 Feb 2004 15:18:58 -0500 Date: Thu, 26 Feb 2004 15:18:58 -0500 From: Mladen Gogala To: oracle-l@freelists.org Subject: Re: Moving db to linux Message-ID: <20040226201858.GC15262@mladen.wangtrading.com> References: <20040226200113.59402.qmail@web41301.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline In-Reply-To: <20040226200113.59402.qmail@web41301.mail.yahoo.com> (from mkb125@yahoo.com on Thu, Feb 26, 2004 at 15:01:13 -0500) X-Mailer: Balsa 2.0.16 Lines: 181 X-archive-position: 2157 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mladen@wangtrading.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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" 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@freelists.org > > [mailto:oracle-l-bounce@freelists.org] On Behalf Of > > Tanel P?der > > Sent: Thursday, February 26, 2004 1:39 AM > > To: oracle-l@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 > > > > To: oracle-l@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 > > To: oracle-l@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@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 > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@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@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 -----------------------------------------------------------------