Re: Moving db to linux

Moving db to linuxSorry, 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@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 
    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> 




    
______________________________________________________________________________
    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: