If i have a dumpfile and no logfile how can i find out what command was used to create that dumpfile?
So if i had a file called test.dmp how do i know what command created that?
I know it was created using this command:
expdp / schemas=aligne flashback_time=systimestamp directory=scratch metrics=y dumpfile=test.dmp logfile=test.log
but how can i find that out 6 months later if there is no logfile?
Answer.....
impdp / dumpfile=test.dmp directory=scratch master_only=y keep_master=y job_name=test
WHich just uploads the master table out of the dumpfile which contains all of the metadata about the job - including the command used to create it.
Once the table is loaded all you have to do is run the right query to extract that information:
So if i had a file called test.dmp how do i know what command created that?
I know it was created using this command:
expdp / schemas=aligne flashback_time=systimestamp directory=scratch metrics=y dumpfile=test.dmp logfile=test.log
but how can i find that out 6 months later if there is no logfile?
Answer.....
impdp / dumpfile=test.dmp directory=scratch master_only=y keep_master=y job_name=test
WHich just uploads the master table out of the dumpfile which contains all of the metadata about the job - including the command used to create it.
Once the table is loaded all you have to do is run the right query to extract that information:
select value_t
from ops$oracle.test
where name = 'CLIENT_COMMAND'
and process_order = -59
Which gives you:
Comments
Post a Comment