Exp/Imp

[Vandy02]

I need to export a full database...

Then import the database

I am exporting from one oracle to another....both 8i

 

[SantaMufasa]

Vandy,

Although you can do a full database export, I find that exporting and importing by schema (Oracle user) is a nice way to do it. To see (on-screen) all available imp/exp parameters, at your o/s prompt, enter "exp help=y" or "imp help=y".

Although there are dozens of imp/exp-parameter combinations that would work for you, here are examples of the command-lines that I typically use (all on one line):

exp buffer=15000000 compress=n grants=y feedback=1000 consistent=y file=SUMMIT.dump log=SUMMIT_Exp.log owner=SUMMIT userid=SUMMIT/SUMMIT@service

imp buffer=15000000 grants=y feedback=1000 fromuser=SUMMIT touser=SUMMIT file=SUMMIT.dump log=SUMMIT_Imp.log userid=SUMMIT/SUMMIT@dhunt

Cheers,

Dave
Sandy, Utah, USA @ 19:32 GMT, 12:32 Mountain Time

 

[Vandy02]

Hmmm...I tried this button...something keeps stopping me...

SP2-0734: unknown command beginning "exp buffer..." - rest of line ignored.
SP2-0042: unknown command "compress=n" - rest of line ignored.
SP2-0042: unknown command "grants=y" - rest of line ignored.
SP2-0734: unknown command beginning "feedback=1..." - rest of line ignored.

I am not able to use the HELP...I assume it may not be installed any ideas?

 

[SantaMufasa]

Vandy,

As I alluded in my first post ("...at your o/s prompt...&quot, "exp" and "imp" are NOT SQL*Plus commands, they are Oracle utilities that run from your operating system (o/s) prompt. The errors you are seeing come from trying to execute the "exp" command from a SQL*Plus prompt. Try it from your operating system command prompt and then let us know the results.

Dave
Sandy, Utah, USA @20:54 GMT, 13:54 Mountain Time.

 

[Vandy02]

Santa...I got it to export..thanks..

When I import this it will be into a another oracle with the same version, but on a separate machine...can you provide me a link of where I can find the process to imp the full dump so I will be able to use it as in the database it has been dumped from...

thanks

 

[SantaMufasa]

Vandy,

The IMP command I posted above actually matches your scenario: the EXP occurred on one Oracle instance/db ("service&quot and the IMP occurred on another Oracle instance/db ("dhunt&quot.

And, as I mentioned, I break up exports and imports BY SCHEMA (Oracle user) instead of a "full database export/import". I do this for multiple benfits: 1) file-size managability and 2) non-serial exporting and importing: I can export multiple schemas simultaneously and them import the schemas simultaneously, versus the limitation of serial file processing if I have done a "full database export/import".

But, if you insist on doing export and import for the full database, then the easiest method is to use "conversational mode" versus "command-line mode". At your o/s prompt, invoke the utility:
1) either "exp" or "imp" [enter]
2) Enter an Oracle username that has been granted the privilege, "IMP_FULL_DATABASE" or "EXP_FULL_DATABASE".
3) Enter the appropriate password for that user
4) Enter responses of your choice to the next two prompts
5) For the next question, enter "E" for "Entire Database"
6) Respond to the remaining prompts as you choose/need.

Dave
Sandy, Utah, USA @ 21:01 GMT, 14:01 Mountain Time