-
oracle 9i export problem
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'
pls help me???????
thanks in advance
-
Do what Oracle is telling you to do...
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.
-
If you want to perform export operation from command prompt ignore that OEM and error.
Try this..,
d:\> exp scott/tiger file=emp.dmp tables=(emp) log=emp.log
it should work and your output file will be in d:\