Hi
Kindly tell me how to use job_name parameter in expdp?When i executed dba_datapump_jobs it resulted as "No rows selected".How to create job??:confused:
Printable View
Hi
Kindly tell me how to use job_name parameter in expdp?When i executed dba_datapump_jobs it resulted as "No rows selected".How to create job??:confused:
Maybe you would find the answer if you read the fine Oracle® Database Utilities manual.
:rolleyes:
I exported my database using Expdp with parameters directory,dumpfile,username/pwd,full and job_name and it succeded.When i tried to findout the jobnames in the database it resulted as no rows selected.
Is this jobname differs from the jobname which i gave while Expdp?
The default of job_name is SYS_EXPORT_SCHEMA_01, you can setting job_name:Quote:
Originally Posted by littleangel
E:>expdp study/study dumpfile=study.dmp schemas=study job_name=pump_test_job
you can select job_name, you issue DML:
select job_name,operation,job_mode,state from user_datapump_jobs;
dba / user_datapump_jobs dictionary views only identifies all the active data pump jobs in the database. As your job is already succeded they won't display any rows.Quote:
I exported my database using Expdp with parameters directory,dumpfile,username/pwd,full and job_name and it succeded.
Thanks,
I tried this but still it doesnot works..
Ok..Thank you Vijay..
As the job has been succeeded how can i attach job to the Expdp?
you can't attach the completed job.
what are you trying to do? what is your requirement?
Thanks,
I want to try "attach" Parameter in Expdp