Tagged Questions
3
votes
1answer
395 views
How to find the schema name of a data pump dmp file?
I have been given a DMP data pump export file to import into my local Oracle instance. I've tried running this command line:
impdp full=Y directory=DATA_PUMP_DIR dumpfile=MyDumpFile.dmp ...
4
votes
1answer
210 views
Comments in EXPDB parameter file
Is there a way to put comments in a data pump export parameter file?
1
vote
1answer
2k views
ORA-39165 Schema was not found in export
I'm getting the following error on a data pump export:
ORA-39165: Schema OFDAT was not found.
First I verified that I had full export permission:
GRANT EXPORT FULL DATABASE TO OFDAT;
Then I ...
5
votes
3answers
642 views
How can a datapump export have its resource usage limited on windows?
Doing an export of a number of users causes high CPU and I/O usage. I can mitigate the effects of the CPU usage using Resource Manager and setting the export session to a low priority group, but how ...
8
votes
1answer
281 views
How can a datapump export have its resource usage limited on linux?
Doing an export of a number of users causes high CPU and I/O usage. I can mitigate the effects of the CPU usage using Resource Manager and setting the export session to a low priority group, but how ...
