Expdp

[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??

[LKBrwn_DBA]

Maybe you would find the answer if you read the fine Oracle® Database Utilities manual.

[littleangel]

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?

[Great Wall]

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??

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;

[vnktummala]

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,

[Great Wall]

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!

[littleangel]

Thanks all for ur updates

[littleangel]

I tried this but still it doesnot works..

[littleangel]

Ok..Thank you Vijay..

[littleangel]

As the job has been succeeded how can i attach job to the Expdp?