Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Moving db to linux

RE: Moving db to linux

From: Nelson, Allan <>
Date: Thu, 26 Feb 2004 11:14:03 -0600
Message-ID: <>

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,

	-----Original Message-----
	From: [] On Behalf Of Tanel Põder
	Sent: Thursday, February 26, 2004 1:39 AM
	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



		----- Original Message ----- 
		From: Tanel Põder <>  
		Sent: Thursday, February 26, 2004 9:28 AM
		Subject: Re: Moving db to linux

		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.

			----- Original Message ----- 
			From: Nelson, Allan <>  
			Sent: Wednesday, February 25, 2004 7:22 PM
			Subject: Moving db to linux

			Im, going to be moving a 220 GB database from HP-UX to Red Hat AS 3.0 running  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 < <> > ______________________________________________________________________________ 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] ----------------------------------------------------------------
Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.
Archives are at
FAQ is at
Received on Thu Feb 26 2004 - 11:17:31 CST

Original text of this message