prince
Posts : 4
Points : 8
Reputation : 0
Join date : 2009-06-22
|
 Subject: How to import dump file using IMP??  Wed Jul 01, 2009 3:57 am |
|
|
Can somebody please explain me how can one import a dump file using IMP??
I have posted this in many forums but no one wants to answer such intelli-questions 
|
|
Admin
Admin
Posts : 34
Points : 103
Reputation : 0
Join date : 2009-06-19
Location : TORONTO,CANADA
|
| Subject: Importing a dump file using IMP--answer Wed Jul 01, 2009 4:13 am |
|
|
This command is used to import Oracle tables and table data from a
*.dmp file created by the 'exp' tool. This a command that
is executed from the command line through $ORACLE_HOME/bin and not within SQL*Plus.
The syntax for importing a dump file is:
imp KEYWORD=value
There are number of parameters you can use for keywords.
To view all the keywords:
imp HELP=yes
An example:
imp angel/angelpassword FILE=mydump.dmp FULL=yes
|
|
