| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Moving db to linux
or netcat, should rsh be outlawed at your site.
Mladen Gogala <mladen_at_wangtrading.com>
Sent by: oracle-l-bounce_at_freelists.org
02/26/2004 12:18 PM
Please respond to oracle-l
To: oracle-l_at_freelists.org
cc:
Subject: Re: Moving db to linux
What you need is a magic wand. On Solaris, it's called "rsh".
The spell goes like this:
System A, prior to the operation:
mknod expdat.dmp p
System B, prior to the operation:
mknod exp_remote.dmp p
System A, engaging the enemy:
exp parfile=myexp.par 2>/dev/null &
dd if=expdat.dmp|rsh dd of=exp_remote.dmp
imp parfile=myimp.par file=exp_remote.dmp log=/vmunix
On 02/26/2004 03:01:13 PM, mkb wrote:
> 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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- 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:27:32 CST
 |
 |