Re: Import

Bricklen's response is perfectly right, though I'd not invoke imp or exp inside SQL*PLUS, I think that was a "if you wanted to do that" kind of answer.

Read up in the manual, there are a lot of tricks using IMP and EXP that can make things go faster, etc; particularly dog-ear / sticky note and highlight the infamous page that I don't think yet has been even bolded or boxed or otherwise marked PAY ATTENTION, in the EXP and IMP sections, regarding proper exports to reconstruct a whole database. Most people think a full export is all they need. Don't learn the way I did about that.

You need two exports, a complete and an incremental taken right after it, with RECORD=Y (and for God's sake, COMPRESS=N, especially on the big one).

For recovery, the incremental is imported with INCTYPE=SYSTEM., then the biggie is sucked in,
and then the incremental is imported again.

Otherwise all sorts of things get loused up that are distinctly unpleasant to fix by hand.

The Oracle Utilities Reference Manual, or whatever the infamous book is now called that documents SQLLDR, IMP, and EXP, has been voted the most universally hated piece of official Oracle documentation ever written by most every DBA I've known or worked with. If you don't have a copy, you can read it online or print it after joining Oracle's TechNet program that you can navigate to on the Web from Oracle's main web site.

Good luck!

RSH. "Rayden" <durlecht_at_msu.edu> wrote in message news:a5dj8i$4t2$1_at_msunews.cl.msu.edu...
> hey,
>
>
> i am trying to figure out how to use import in oracle 9i.....from what i
> read there is a command called 'imp'......however that command does not
> exist when i type it in sql plus. what am i doing wrong? is there a
> graphical interface with this as well?
>
>
> thanks in advance,
>
>
> timis
>
>
Received on Mon Feb 25 2002 - 17:10:38 CST