Re: Copying database from one NT to another UNIX

Recordlength is likely to be the same or does not matter, in spite of what the manual says. Not sure about the flavor of UNIX Mueller is talking about. I copied data from NT to Linux by export/import without specifying recordlength.

Yong Huang

Tonal <tonal_at_pestilence.net> wrote in message news:396C56C3.AEAF0087_at_pestilence.net...
> Sybrand Bakker wrote:
> >
> > "Mueller" <muellerhans_at_gmx.de> wrote in message
> > news:396b595f$0$6052_at_businessnews.de.uu.net...
> > > Hi,
> > >
> > > Can you please show me the best way to copy the database (8.1.6) from
 one
 NT
> > > to another UNIX (8.1.6).
> > > (exp imp?)
> > >
> > > Thanks for help
> > >
> > >
> > >
> > >
> >
> > Full database export on NT
> > exp username/password full=y direct=y file=<whatever> log=<whatever>
> > compress=N
> >
> > Full import on Unix
> > imp username/password full=y commit=y ignore=y file=<whatever>
> > log=<whatever> etc.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
>
>
> You should specify the recordlength also - different
> environments have different defaults.
> --
> "He, who will not reason, is a
> bigot; he, who cannot, is a fool;
> and he, who dares not, is a slave."
> -William Drummond, (1585-1649).
Received on Wed Jul 12 2000 - 00:00:00 CDT