RE: Moving db to linux

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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: