Results 1 to 11 of 11
  1. #1
    Join Date
    Aug 2006
    Posts
    6

    Unanswered: export problem on oracle 9iDB

    Hi,

    I am a new user. I need help.

    When i export data from 9i db,get error message as follow:
    exp-00008: ORACLE error 1422 encountered
    ORA-01422: exact fetch return more than requested number of rows
    ORA-06512: at "SYS.STANDARD", line 628
    ORA-06512: at "SYS.DBMS)RULE_EXP_RULES", line 129
    ORA-06512: at line 1
    EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP
    _RULES.schema_info_exp
    Can anyone tell me how to fix this problem?
    Thanks for all.

    Best Regards.
    Thomas Chang.

  2. #2
    Join Date
    Oct 2005
    Posts
    61
    Please post what your requirement is and what commands you typed (the exact commands).

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    issue the following select

    select count(*) from sys.dual;

    The returned value MUST be 1, If it is anything else, your dual table has been corrupted.

    You should also only have ONE dual table in your system, Issue the following command.

    select owner,object_type
    from all_objects
    where object_name='DUAL';

    You should have one table in SYS and one synonym in PUBLIC and depending on packages loaded, one view in system
    Last edited by beilstwh; 08-02-06 at 13:25.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Aug 2006
    Posts
    6
    Hi,Beilstwh

    Thanks for you message. But can you tell me how to fix dual table?
    Drop and create it.

    Thomas Chang.

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I hope you didn't mess with DUAL (or any SYS owned table) ... read this Ask Tom article about DUAL.

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    To be able to fix the problem, I need to see the results of the queries that I gave you. Please paste them into a forum message.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    If your SYS.DUAL table has more then one row, the easiest way to repair it is as follows. Do NOT skip any steps. and do the following steps as a dba user. Do NOT drop the DUAL table, you will be in a world of hurt if you do.

    delete from sys.dual;
    insert into sys.dual values('X');
    commit;


    Now that it is corrected, NEVER,NEVER,NEVER mess with any table in SYS.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  8. #8
    Join Date
    Oct 2005
    Posts
    61
    Hi Beilstwh,

    Did you experience a similar (or same ) problem anytime before? How did you guess the dual table to be corrupted?

    Thanks,
    Srinivas

  9. #9
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    No, I have never had a corrupted DUAL, however the ORA-01422 on a standard export almost has to be a problem with DUAL.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  10. #10
    Join Date
    Aug 2006
    Posts
    6
    Hi,Beilstwh

    Thanks for you help. I solved this problem. Yes, You are right.
    Thanks for all.

    Thomas Chang.

  11. #11
    Join Date
    Oct 2005
    Posts
    61
    Thanks Beilstwh!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •