Brilliant Strategies Of Tips About How To Restore Dmp File In Oracle 10g

Web how to restore oracle 10g database from backup.

How to restore dmp file in oracle 10g. Web if this is the case: Web at the rman prompt, restore the server parameter file from autobackup using the command restore spfile from ''; Since i am new at 10g, i received some dmp files from a client and need to restore them.

It depends what you are trying to do but one short answer is: Web you can import a file in to database using folloeing import command: I am a sql dba crossing over and need some help asap!

Web this video tutorial is created for all those beginners who want to import any.dmp file from another oracle database to their own database. Web i've installed oracle 10g and now i need to restore the original database.can anyone give me a step by step procedure for how to restore it from the *.dmp file ?ans. Web please provide me answers as soon as possible.my database is fresh and i want to restore the dmp file in my database, that dmp file is exported by oracle 10g.

Imp scott/tiger file=emp.dmp log=imp.log full=yes to import dept. Imp system/password@sid file= (filename) log=imp.log fromuser= (existing user) touser=. Web you can view the dump file contents using toad (must be fully licensed with the dba extension), imp or impdp.

To import full dmp file: Connect to the server, set oracle_home=/where/is/oracle/home/ set path=%oracle_home%/bin;%path% set. Web hello, oracle forum.