RE: Moving db to linux

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]

Other related posts: