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_at_midf.com> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> Tanel Põder
> Sent: Thursday, February 26, 2004 1:39 AM
> To: oracle-l_at_freelists.org
> 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_at_mail.ee>
>
> To: oracle-l_at_freelists.org
> 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_at_midf.com>
> To: oracle-l_at_freelists.org
> 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_at_midf.com <mailto:anelson_at_midf.com
> <mailto:anelson_at_midf.com> >
>
>
>
>
>
> 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_at_freelists.org
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
-----------------------------------------------------------------
Received on Thu Feb 26 2004 - 14:02:06 CST
