when ever we come across the "expdp ORA-31633" error... this means we need to remove the outstanding jobs that are already in there or using that table....
"ORA-00955: name is already used by an existing object"
we need to find the tables that are already been there and are not dropped once the expdp/impdp jobs are performed.(usually these are gone if the jobs exits normally without any errors/interruptions..)
"ORA-00955: name is already used by an existing object"
we need to find the tables that are already been there and are not dropped once the expdp/impdp jobs are performed.(usually these are gone if the jobs exits normally without any errors/interruptions..)
select owner_name, job_name, operation, job_mode,state,
attached_sessions from
dba_datapump_job where
job_name not like 'BIN$% order
by 1, 2;
If you see the tables... drop them.... and then try the expdp job again. This time it should work...
Hope this helps...
No comments:
Post a Comment