Data Pump Export Fails

Posted on 2006-04-19
Last Modified: 2010-08-05
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.

Question by:mjimison1956
    1 Comment
    LVL 47

    Accepted Solution

    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.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now