Importing dmp file
Home > IT Answers > Oracle > Importing dmp file
PSS
10 pts.
0
Q:
Importing dmp file
Oracle import/export, DMP Importing
What is the procedure for importing a dmp file?
ASKED: Apr 20 2009  7:47 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Inprise
540 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
This tip has some good info. You have to register but its free
%0
Last Answered: Jul 22 2009  9:13 AM GMT by Inprise   540 pts.
Latest Contributors: Carlosdl   29855 pts., ITKE   10345 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Inprise   540 pts.  |   Jul 22 2009  9:12AM GMT

Hi,

You can use import(imp) in case of 9i

else import data pump in case of 10g

YOu should identify wat way the export dump is generated using imp or impdp

Here is the syntax

For import

grant unlimited tablespace to ZZZZZZZ

ZZZZZ == can be list of schemas to be imported

imp file= XXXX.dmp log=aaaa.log full=y

Here XXXX - dump file
aaaa - log name
full =y represents all schemas

For import datapump

impdp directory=data_pump_dir dumpfile=XXXX.dmp logfile=aaa.log

Regards
Inprise

 
0