-
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??
-
SYS_EXPORT_<mode>_NN
Maybe you would find the answer if you read the fine Oracle® Database Utilities manual.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
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?
LittleAngel
DBA-SQL,Oracle
-
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??
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;
-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
I tried this but still it doesnot works..
LittleAngel
DBA-SQL,Oracle
-
LittleAngel
DBA-SQL,Oracle
-
As the job has been succeeded how can i attach job to the Expdp?
LittleAngel
DBA-SQL,Oracle
-
you can't attach the completed job.
what are you trying to do? what is your requirement?
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
I want to try "attach" Parameter in Expdp
LittleAngel
DBA-SQL,Oracle
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|