hi,
i am using oracle 9i.
i had created a table "emp" by logging as "scott/tiger"
i want to export this table using Oracle entreprise manager (OEM)
but it is giving me an error
LRM-00109: could not open parameter file 'C:/WINNT/TEMP/2892120138.dat'
LRM-00113: error when processing file 'C:/WINNT/TEMP/2892120138.dat'
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
what to do now?
content of my init%sid%.ora file : IFILE='D:\oracle\admin\OEMREP\pfile\init.ora'
1- Check if you actually have a valid parameter file on C:/WINNT/TEMP/2892120138.dat
2- If you have any doubts ask Oracle for help e.g. exp help=y
What happens if you run the export manually?
Don't forget to read error messages and documentation carefully, I know for a fact you don't do that because of you have posted your question in the wrong section of the forum.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Reply With Quote
Bookmarks