Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2607
  • Last Modified:

Data Pump Export Fails

I have a 10g database that I can not seem to get the Data Pump export to work on when using from OEM.  Here are the errors from two attempts:

Export Submit Failed
 
 
 
ORA-20204: User does not exist: FIPERDBA ORA-06512: at "SYSMAN.MGMT_USER", line 122 ORA-06512: at "SYSMAN.MGMT_JOBS", line 139 ORA-06512: at "SYSMAN.MGMT_JOBS", line 78 ORA-06512: at line 1  
 


 
   Export Submit Failed
 
 
 
Errors: ORA-31626: job does not exist ORA-31633: unable to create master table "FIPERACS.MKK2" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT", line 863 ORA-01536: space quota exceeded for tablespace 'FIPERTS1' Exception : ORA-31626: job does not exist ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.DBMS_DATAPUMP", line 911 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4356 ORA-06512: at line 2  

Any ideas?  I did an alter user and did unlimited quota on the Tablespace.


Thanks.........immediate help needed.


 
0
mjimison1956
Asked:
mjimison1956
1 Solution
 
schwertnerCommented:
Generally speaking:
Migrate to Release 2 of 10g.
Data Pump works there.

For the particular case:

In the Enterprise Manager Console, add the user who will run the Export/Import
DataPump job as an Administrator who can login to Enterprise Manager to perform
management tasks like set Blackouts, email notification schedules.

- login as user SYSTEM (or user SYS) to the 'Enterprise Manager 10g
  Database Control'
- At the top right, click on the link 'Setup'
- On the page 'Administrators', click on the button 'Create'
- On the page 'Create Administrator: Properties', add the user who will run
  the Export/Import DataPump job
- Click on the button: 'Finish'
- On the page 'Create Administrator: Review', click on the button: 'Finish'
- On the page 'Administrators', confirm that the user has been added.
- At the top right, click on the link 'Logout'

Now login as the user who will run the Export/Import DataPump job (SCOTT),
and re-create the DataPump job.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now