Have Geek Brain

Oracle EX and SQL Plus: How to Recover a Dump File?

I have .dmp and .log files. I need to restore database schema and data using SQLPlus or some EX function. How can I do it? I have tried RECOVER and impdp command. Bad luck or I am doing something wrong.

0


a source to share


3 answers


What version of Oracle? How was the .dmp file created? You can look at the first line in your .dmp file (assuming it's a file generated by exp) to get the version of the utility that dumped it. You will probably need to use imp, although I don't know what problems you are having with impdp messages - errors and the command line used would be helpful. Assuming this was produced by exp, RECOVER won't help.



0


a source


Can you use "imp Scott / Tiger @Machine file = MyDump.dmp" in EX?



PS: I am assuming Oracle Ex == Oracle Express

0


a source


open command prompt and type imp user / password @db you will be prompted to provide file and path.

if you get a message like: IMP-00010: invalid export file, header check error IMP-00000: Import failed, this means that the file was created by the data pump or the original version is newer. if not, follow the prompts to get really straight forward.

0


a source






More articles:


All Articles