Also when you FTP the files make sure you do it in binary mode! If you do
it in ASCII mode then the file will be useless. If you don't know what
binary mode in ftp is look it up.
Jim
"Howard J. Rogers" <howardjr_at_www.com> wrote in message
news:3be785c8$0$1772$afc38c87_at_news.optusnet.com.au...
> How do you use them in detail? Easy. You read the *very* extensive
Oracle
> documentation on both utilities, available at technet.oracle.com for free
> (you have to become a member of the site to access the documents, but
> membership is free and instantly available).
>
> Next, you ask your boss why you are being dumped with a task for which you
> would appear, at this stage in your career, singularly unqualified.
>
> Third, you go to the command line and type "exp help=y" (without the
quotes
> of course) to discover all the command line parameters that can be
specified
> (refer back to the documentation to find out what each parameter means in
> detail). You can also do imp help=y to find out the parameters that
import
> uses.
>
> And fourthly, you'll discover that a migration will go something along the
> lines of exp system/manager full=y file=something.dmp, whereupon you ftp
the
> something.dmp file to the second machine, and run imp system/manager
full=y
> file=something.dmp.
>
> And the most important one of those four steps is number 2, closely
followed
> by number 1.
>
> Regards
> HJR
> --
>
> Oracle Resources : http://www.hjrdba.com
> =============================
>
>
> "Stefan Dohn" <stefan.dohn_at_t-online.de> wrote in message
> news:9s6rjh$h1g$02$1_at_news.t-online.com...
> > Hey there, I have 2 Linux Servers whith Oracle
> > 8.1.6 my boss told me to migrate all tablespaces
> > from on maschine to the second. But I can not find
> > a way to do this. Can someone tell me in detail
> > how I can do that ? Yes, I see there are imp and exp,
> > but how to use them in detail ?
> >
> >
> >
> >
> >
>
>
Received on Tue Nov 06 2001 - 07:40:49 CST
