Expdp

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?

Quote:

---

Originally Posted by littleangel

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:

---

The default of job_name is SYS_EXPORT_SCHEMA_01, you can setting job_name:

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;

Quote:

---

I exported my database using Expdp with parameters directory,dumpfile,username/pwd,full and job_name and it succeded.

---

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.

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

You can only test that if the job is not completed irrespective of what state it is.

Read the "Examples of Using Data Pump Export" in the link provided by LKBrwn.

Thanks,

Quote:

---

Originally Posted by vnktummala

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.

Thanks,

---

good job!

Thanks all for ur updates