Re: Copying database from one NT to another UNIX

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).