Re: Moving db to linux
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 Feb 2004 09:38:59 +0200
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:
